Unable to create MSSQL databases, it fails with the following error message:
PLESK_ERROR: Error: There are no available resources of this type (MySQL databases) left. Requested: 1 available: 0.
The affected subscription has MSSQL database resources available in its assigned Service Plan, but it has reached the MySQL databases limit.
This is a Plesk bug with ID #PPP-46436 which will be fixed in upcoming Plesk updates.
Note: Subscribe to this article to get a notification once this issue will become fixed.
As a workaround, increase the MySQL databases limit of the subscription at Service Plan or Subscription level:
Click on a section to expand
Go to Service Plans > Click on the Service Plan assigned to the subscription > Resources tab > Increase the MySQL databases limit > Click on Update & Sync to apply the changes to all the subscriptions assigned to this Service Plan
Note: The subscription will become locked and any changes performed on the Service Plan will not be synchronized with this subscription: How to synchronize locked subscriptions with their service plans
Go to Subscriptions > example.com > Account section placed on the right-side > Click on Customize:
In the Resources tab > Increase the MySQL databases limit > Click on Update & Lock to apply the changes only to the affected subscription