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'.
"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"
Cancel all the tasks related to subscription provisioning.
Remove failed subscription under Operations > Subscriptions
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".
- Recreate subscription.