Symptoms
-
Unable to select MS SQL database under Subscriptions > example.com > Databases > Add Database > Database server: only MySQL database is available.
-
Unable to select MS SQL database under Databases > Add Database > Database server: only MySQL database is available.
Cause
The number of MS SQL databases is limited for the webspace, subscription’s or reseller’s plan.
Resolution
Web Admin Edition
-
Go to Tools & Settings > License Management and check if Microsoft SQL Server support enabled or not:
-
If no, then it is required to purchase the MSSQL support first for the subscription.
MSSQL support is included in the Power Pack and Developer Pack.
-
If yes, then proceed to step 3.
-
-
Run the command below to get the current limit of MSSQL databases for the required webspace:
C:> plesk bin subscription_settings –info example.com | 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):
C:> plesk bin subscription_settings -u example.com -max_mssql_db 100
plesk bin subscription_settings -u example.com -max_mssql_db -1
Web Pro and Web Host Editions
-
Go to Subscriptions > example.com > Account > Resources.
-
Find the MS SQL databases number.
-
If it reached its limit, increase it of the following ways:
Go to Subscriptions > example.com > Customize > Resources page and increase the MS SQL databases limit (changes will affect only this subscription).
Go to Subscriptions > example.com > Service Plan: Default > Resources page and increase the MS SQL databases limit (changes will affect all subscriptions assigned to this service plan).
-
If it is not reached the limit, then this limit is set on the reseller’s level as also. Follow to the next step.
-
-
Go to Subscriptions > example.com > Subscriber: John Doe > Provider: Jane Doe.
-
Click the Change Plan button to increase the MS SQL databases number for all resellers assigned to this service plan.
Click the Customize button to increase the MS SQL databases number only for this reseller.
-
Find the MS SQL databases number and increase it to the required value.