Sometimes you may find the physical hosting for a domain disabled in Plesk, but the website active in IIS. While trying to activate the hosting, it will throw the following error
"Hosting not activated because it suspended by the hosting service provider"
It means that while unsuspending the subscription, the subscription and the website in IIS got activated, but the value in the database did not change. In order to resolve this issue, perform the steps given below.
Assuming the plesk database is stored in MS SQL.
1. Open SQL Server Management Studio via Start --> Program Files --> Microsoft SQL Server 2008 R2 --> SQL Server Management Studio.
2. Login using sa credentials
3. Open Query window from File --> New --> Query with current connection. Alternatively, you can also click on the New Query option displayed below the file menu.
4. Switch the current database to the Plesk database.
5. Run the following query to check the status of the hosting for the domain.
select status from domain where name='domain_name' where domain_name is the name of the domain whose hosting is disabled.
6. If the value is '2', it means it is disabled. In order to activate it, run the following query.
update domain set status=0 where name='domain_name' where domain_name is the name of the domain whose hosting is disabled.
If the plesk database is stored in MySQL (by default it is created in MySQL), the same queries should be run in MySQL database. Following are the complete steps.
1. Connect to the MySQL database from command prompt using the following commands
cd %plesk_dir%\MySQL\bin
mysql -P8306 -uadmin -p<plesk_admin_password> psa
2. Run the following query to check the status of the hosting for the domain.
select status from domain where name='domain_name' where domain_name is the name of the domain whose hosting is disabled.
3. If the value is '2', it means it is disabled. In order to activate it, run the following query.
update domain set status=0 where name='domain_name' where domain_name is the name of the domain whose hosting is disabled.
