One of the challenges with creating a completely deployable service in the past has been the lack of ability to sysprep SQL Server. That was addressed with SQL Server 2012 so that you could sysprep a SQL Server cleanly and include a sysprep’d VM template in a service template. Now with SQL Server 2012 SP1 CU2, we have expanded the number of features that can be sysprep’d! Below is a blog post by Robert Hutchison who is now a PM with the SQL group, but used to be a PM on the System Center team. Thanks for writing this up Robert!
Hello everyone, my name is Robert Hutchison and I am a Program Manager on the SQL Server team. Today I wanted to let you know about some improvements we have made to the SQL SysPrep support in SQL Server 2012 SP1 CU2. These improvements will allow you to leverage business intelligence and other SQL Server features in the VHDs you create for use on-premise and Windows Azure VMs.
Earlier versions of SQL Server supported the preparing of images by using SQL Server SysPrep. This enabled images to be prepared with desired features and then completed later. However, there were many major features that were not supported by SQL Server SysPrep. Expanding the supported features for SQL Server SysPrep to include SQL Server Analysis Services, SQL Server Integration Services, and shared features enables SQL Server SysPrep to be used in a wider variety of image preparation scenarios.
The following screen shows the set of features supported by SQL SysPrep in SQL Server 2012:
As you can see from the screen shot, the set of features is limited to Instance features.
The following screen shows the updated set of features supported by SQL SysPrep in SQL Server 2012 SP1 CU2:
The set of features supported for SQL SysPrep scenarios has been greatly enhanced to support some of the most requested features including Analysis Services, Integration Services and shared features such as Management Studio. This should make SQL SysPrep useful in a wider set of image preparation scenarios.
How can I use these new Sysprep features?
Since this functionality is being released in a Cumulative Update, some steps must be taken prior to leveraging them. Specifically a slipstream installation must be created in order to access the new functionality. Once the slipstream package is created, it’s just a matter of running setup in order to access this functionality. The following screen shows the location for the SysPrep preparation:
The new SQL SysPrep functionality provides more image preparation options in cases where SQL Server is to be installed on the prepared image. This allows Windows images to be prepared that have SQL Server features prepared in advance. This provides streamlined process for on-premise as well as Azure VM image provisioning scenarios.
The following links provide more details on the topics discussed:
For details regarding SQL Server installation using SysPrep and configuration file generation, see the following site:
For more information on creating a slipstream package that includes a cumulative update, please refer to the following excellent blog post by our team member Ahmed Ibrahim:
Ik wil best u houden maar sluit A.U.B. mijn E.Mail aan echt
How do we use this with SCVMM 2012 SP1 SQL Server Profiles?
Hi there, I am trying to sysprep SQL Server 2012 for VMs But cannot get the full features list to come up. (I only get the reduced size!)
I have downloaded the SP1 iso from here
Any ideas of what I could try to get the full feature list?
Thanks Travis. Quick question. I want to build a zero-touch image. I have a prepared and syspreped SQL2012 image. I would like to complete the installation during windows setup so SQL is ready before the user logs in. When I run the SQL setup with the
CompleteImage option (as a RunSyncronousCommand) it fails saying that .Net 3.5 is not installed. Does anyone know how to complete the install w/o having a user log in and run the CompleteImage task?