Deploying a DAC pack in System Center 2012 Virtual Machine Manager fails if using a named SQL instance
When deploying a SQL DAC pack (Data Tiered Application) using System Center 2012 Virtual Machine Manager, if the name of the SQL instance in the DAC pack is blank then the service template will fail with the following error:
The connection to SQL Server on the virtual machine (VMName) failed for the SQL Server data-tier application (Application Name).
DetailedErrorMessage: Failed to connect to server (local).
Verify the specified SQL Server connection information for the SQL Server data-tier application.
When deploying a DAC pack or creating a SQL server using a Service template, the SQL instance must match the instance name specified when you created the generalized VHD (Syspreped). Otherwise the service template will fail with Instance Not Found.
Edit the DAC pack to specify the correct instance name or edit the Service template to match the instance name of the original VHD.
for other considerations.
Article ID: 2679704 - Last Review: 05/08/2012 18:21:00 - Revision: 3.0