Unable to add MySQL/MariaDB/MSSQL database in Plesk: the option is missing

Plesk for Windows Plesk for Linux kb: technical ABT: Group A

Applicable to:

The button "Add Database" is missing at Subscriptions > example.com > Databases.
Unable to select MySQL/MariaDB/MS SQL database server at Subscriptions > example.com > Databases > Add Database > Database server.

The number of MySQL/MariaDB/MSSQL databases is limited in the webspace, subscription or reseller plan settings.

Web Admin Edition

For Plesk on Linux

Connect to the Plesk server via SSH.
Increase the database limit (specify "-1" for unlimited):

# plesk bin subscription_settings -u example.com -max_db 100

For Plesk on Windows server

Log in to Plesk.
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 MS SQL 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 (specify "-1" for Unlimited):

C:\> plesk bin subscription_settings -u example.com -max_mssql_db 100

Web Pro and Web Host Editions

Log in to Plesk.
Go to Subscriptions > example.com > Customize (under Account) > Resources.
Find the MySQL/MariaDB/MS SQL databases number:
- If the subscription has reached its limit, increase it using one the following ways:
  
  - Go to Subscriptions > example.com > Customize > Resources page and increase the MySQL/MariaDB/MS SQL databases limit (changes will affect only this subscription).
  
  - Go to Subscriptions > example.com > Service Plan: Default > Resources page and increase the MySQL/MariaDB/MS SQL databases limit (changes will affect all subscriptions assigned to this service plan and synchronized).
- If the subscription has not reached the limit, then this limit is set on the reseller's level.
  
  3.1. Go to Subscriptions > example.com > Subscriber: John Doe > Provider: Jane Doe:
  
  - Click the Change Plan button to increase the MySQL/MariaDB/MS SQL databases number for all resellers assigned to this service plan.
  
  - Click the Customize button to increase the MySQL/MariaDB/MS SQL databases number only for this reseller.
  
  3.2. Find the MySQL/MariaDB/MS SQL databases number and increase it to the required value.