Article ID: 123535, created on Nov 13, 2014, last review on Nov 13, 2014

  • Applies to:
  • Plesk Automation 11.5

Symptoms

Cannot provision "Windows Shared Hosting" subscription including MSSQL2012, task "Prepare data for the database service in the webspace" fails with error:

Unable to find a proper service node for allocating the 'Windows Shared Hosting' subscription.
You should have at least one node that meets the following requirements:
- The node provides the following service(s): 'ppa_mssql'.
- 'Microsoft SQL 2012' attribute(s) are assigned to the node.
- The node is marked as 'Ready to Provide'.

Cause

"Windows Shared Hosting" service template misconfiguration. "Microsoft SQL database" resource is used. This resource is for MSSQL 2008 server. In order to use MSSQL 2012 it is needed to replace this resource with another one - "Microsoft SQL 2012 database"

Resolution

  1. Cancel all the tasks related to subscription provisioning.

  2. Remove failed subscription under Operations > Subscriptions

  3. In service template Subscription replace resource "Microsoft SQL database" with "Microsoft SQL 2012 database" or create a new one service template with resource "Microsoft SQL 2012 database".

  4. Recreate subscription.

Search Words

Unable to find a proper service node for allocating the 'Windows Shared Hosting' subscription.

33a70544d00d562bbc5b17762c4ed2b3 caea8340e2d186a540518d08602aa065 e0aff7830fa22f92062ee4db78133079

Email subscription for changes to this article
Save as PDF