Troubleshooting Deploying SQL 2008R2 Service In VMM 2102

It toke me quite some time to successfully  deploy SQL server as an instance using VMM 2012 , I would like to share my experience with you as I’m sure that a lot of people have faced the same problem due to lack of information or misunderstanding the steps provided by MS Blogs as non-of these blogs declare the secret of deployment laud and clear  Tip 1.

TIP1: 

MS SQL Deploy will be successful only if you are using the “MSSQLSERVER” default instance name 

bellow are the high level steps to create SQL service and problems that you may see. :

1. Install windows 2008R2SP1

2. Open firewall Rules for : port 1433 SQL , open ports for file sharing

3. install SQL in Sysprep mode as per this very nice post by Mike DeLuca http://www.thecloudbuilderblog.com/blog/2012/2/8/how-to-create-a-template-sql-server-vm-and-deploy-it-using-s.html

4. if you are using SQL2008R2 without SP1  install the SQL DAC Framework  or you can create resource package in VMM library and deploy the DAC using Application profile , which will allow you to deploy DB DAC using VMM 2012 service template

http://www.microsoft.com/en-us/download/details.aspx?id=24000

if the DAC Framework is not installed you will see Error (22622) ,Error (22042)

Error (22042)
The service (HMAil DaC 2) was not successfully deployed. Review the event log to determine the cause before you take corrective action.

Recommended Action
The deployment can be restarted by retrying the job.

Error (22622)
SQL Server data-tier application framework of the required version (10.50.1750.9 or higher) is not installed on the virtual machine (StockSQl4.jitpros.local).

Recommended Action
Install the SQL Server data-tier application framework on the virtual machine, and then try again.

Error (20400)
1 parallel subtasks failed during execution.

Error (21952)
Application deployment failed for one or more tiers or application hosts in the service (HMAil DaC 2). Check job logs to get more information on the failed operation.

Recommended Action
Check error messages and retry the operation if needed.

4.sysprep windows and shutdown 

5. Copy the VHD to VMM library

6. when Creating your  SQL Profile , in instance name type MSSQLSERVER for instance name , don’t use other name because it create SQL instance and you find that your deployed SQL server is not accepting connections .  the errors below are due to using other name than MSSQLSERVER for instance name

Error (22042)
The service (New Stock) was not successfully deployed. Review the event log to determine the cause before you take corrective action.

Recommended Action
The deployment can be restarted by retrying the job.

Information (21947)
The script command (c:\windows\System32\cmd.exe  /q /c c:\windows\MSSCVMMSQLInstance\91060814-e1b5-409a-b59a-cedf851b527c\sqlHost.cmd) was executed on the computer (STSQL1.jitpros.local) and returned a result exit code (0).

Error (22528)
The connection to SQL Server on the virtual machine (STSQL1.jitpros.local) failed for the SQL Server data-tier application (SQL Server Data-Tier OrderProcessorRepository).
DetailedErrorMessage: Failed to connect to server (local).

Recommended Action
Verify the specified SQL Server connection information for the SQL Server data-tier application.

Error (20400)
1 parallel subtasks failed during execution.

Error (21952)
Application deployment failed for one or more tiers or application hosts in the service (New Stock). Check job logs to get more information on the failed operation.

 

I hope this will help solve your problem.

Advertisements

About Hikmat Kanaan

I’m big fan of technology; I have worked almost with every MS windows OS up to Windows 8 and server 2012 including OS deployment, AD and almost every MS OS service included major MS products ISA ,TMS, Exchange, System center ,Sharepoint ,SQL , Storage system, Networking, security, Cisco, HP, and Checkpoint products. Designing and Architecting IT solutions and infrastructure . I do admire automation and working based on best practices toward building highly reliable solution that provide the required services to Business. I also run the Jordan IT professionals user Group http://www.jitpros.net
This entry was posted in VMM2012 and tagged , , . Bookmark the permalink.

One Response to Troubleshooting Deploying SQL 2008R2 Service In VMM 2102

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s