You are currently offline, waiting for your internet to reconnect

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:

Error (22528)
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).

Recommended Action
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.
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Article ID: 2679704 - Last Review: 05/08/2012 18:21:00 - Revision: 3.0

  • KB2679704