How to retrieve administrator’s Plesk database password on Plesk 17.8 for Windows and higher

Unable to add MS SQL database in Plesk, only 1 database available.

The number of MS SQL databases is limited for the webspace, subscription’s or reseller’s plan.

Run the command below to get the current limit of MSSQL databases for the required webspace:

plesk bin subscription_settings –info | findstr max_mssql_db

max_mssql_db 30 MS SQL databases

Increase the number of MSSQL databases for the required webspace (use the “-1” to set to the Unlimited value): plesk bin subscription_settings -u -max_mssql_db 100

plesk bin subscription_settings -u -max_mssql_db -1