Error: There are no resources of this type (Microsoft SQL Server databases) available from your service provider. Requested: 1; available: 0.

Created:

2016-11-16 12:39:21 UTC

Modified:

2017-04-24 11:30:45 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Error: There are no resources of this type (Microsoft SQL Server databases) available from your service provider. Requested: 1; available: 0.

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk 11.0 for Windows
  • Plesk 11.5 for Windows
  • Plesk 12.0 for Windows
  • Plesk 12.5 for Windows

Symptoms

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.

Cause

The provider or service plan has not enough resources.

Resolution

Check the following:

  1. Plesk license allows to create MS SQL databases ( Tools and Settings > License Management ).

  2. Subcription' service plan have not enough resources ( Subscriptions > domain.tld > Service plan ).

  3. 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:

  1. Reseller' service plan has not enough resources ( Service Plans > Reseller Plans ).

  2. 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.

Have more questions? Submit a request
Please sign in to leave a comment.