I am trying to add the MS SQL database under subscription and getting the error:
Error: There are no resources of this type (Microsoft SQL Server databases) available from your service provider. Requested: 1; available: 0.
The provider or service plan has not enough resources.
Check the following:
Plesk license allows to create MS SQL databases ( Tools and Settings > License Management ).
Subcription' service plan have not enough resources ( Subscriptions > domain.tld > Service plan ).
If the subscription is locked check the customized resources ( Subscriptions > domain.tld > Customize )
If the subscription assigned to the customer created by reseller, then check the following:
Reseller' service plan has not enough resources ( Service Plans > Reseller Plans ).
If the reseller' subscription is locked check the customized resources ( Resellers > My reseller > Customize )
Locked state means locked for syncing, indicates that a subscription is excluded from syncing with the associated plans.
A subscription gets locked if you change the parameters of the subscription, without changing the associated service plan. Such locking secures your customizations so that they are not overwritten the next time, when you change the plan and all its subscriptions are synced.
Unsynced state indicates that some services or resources offered with the associated plans cannot actually be provided with the subscription.
Read more about relationship between plans and subscriptions.