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

[System-Center-Team]

First published on TECHNET on May 08, 2012

Here’s a new Knowledge Base article we published today. This one talks about an issue where deploying a DAC pack in System Center 2012 Virtual Machine Manager fails if using a named SQL instance.

=====

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.

=====

For the most current version of this article please see the following:

2679704 - Deploying a DAC pack in System Center 2012 Virtual Machine Manager fails if using a n...

J.C. Hornbeck | System Center & Security Knowledge Engineer

Get the latest System Center news on Facebook and Twitter :

App-V Team blog: http://blogs.technet.com/appv/
ConfigMgr Support Team blog: http://blogs.technet.com/configurationmgr/
DPM Team blog: http://blogs.technet.com/dpm/
MED-V Team blog: http://blogs.technet.com/medv/
Orchestrator Support Team blog: http://blogs.technet.com/b/orchestrator/
Operations Manager Team blog: http://blogs.technet.com/momteam/
SCVMM Team blog: http://blogs.technet.com/scvmm
Server App-V Team blog: http://blogs.technet.com/b/serverappv
Service Manager Team blog: http://blogs.technet.com/b/servicemanager
System Center Essentials Team blog: http://blogs.technet.com/b/systemcenteressentials
WSUS Support Team blog: http://blogs.technet.com/sus/

The Forefront Server Protection blog: http://blogs.technet.com/b/fss/
The Forefront Endpoint Security blog : http://blogs.technet.com/b/clientsecurity/
The Forefront Identity Manager blog : http://blogs.msdn.com/b/ms-identity-support/
The Forefront TMG blog: http://blogs.technet.com/b/isablog/
The Forefront UAG blog: http://blogs.technet.com/b/edgeaccessblog/