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 2> go 1> exit