Deploying a DAC pack in System Center 2012 Virtual Machine Manager fails if using a named SQL instance

Article ID: 2679704
Expand all | Collapse all

Symptoms

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.

Cause

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.

Resolution

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.

Properties

Article ID: 2679704 - Last Review: May 8, 2012 - Revision: 3.0
Keywords: 
KB2679704

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com