Cannot activate a subscription in Parallels Plesk . It fails with the following error:
Error: Enable database user failed: Database 'db_name' cannot be opened because it is offline.
The database status was changed to Offline manually.
In Microsoft SQL Server Management Studio hit Databases > right-click on db_name > Tasks > Bring Online .
Alternatively it can be done in command line:
C:\\ cd %plesk_bin%
C:\\Program Files (x86)\\Parallels\\Plesk\\admin\\bin>osql -E
1> ALTER DATABASE db_name SET ONLINE