SQL Server 2008 R2 Sysprep Step by Step


Starting in SQL Server 2008 R2, we have added Sysprep functionality. The Sysprep functionality enables rapid deployment and configuration of SQL SQL Server.  The SQL Server sysprep functionality allows you to install files and then configure at a later point. SQL Server Sysprep can be used with Windows Sysprep to create an operating system image that includes an unconfigured SQL Server installation. After completing the configuration of the operating system, you can then configure the SQL Server install using the “Complete Image” wizard. The Sysprep functionality is available in all SQL Server 2008 R2 editions.

 

There are 2 different phases:

(1) Preparing the image by installing the files on to the system for the features that are selected. At this point, the features are not usable

(2) Configure the features to be useable. At this point the instance, networking and service accounts are configured. Once the image is configured the SQL Server image can be used.

 

Limitations:

  • Only the database engine and reporting services supports Sysprep
  • Cannot be used for clustering scenarios
  • Not supported on IA64 system or supported in WOW64
  • The installation media need to be available when preparing an image and configuring the image. When Sysprepping a SQL Server Express, you need to extract the files to the local machine before preparing the image.

 

See http://msdn.microsoft.com/en-us/library/ee210754(SQL.105).aspx for an overview of SQL Server sysprep and http://technet.microsoft.com/en-us/library/ee210664(SQL.105).aspx for additional information on how to install in the SQL Server 2008 R2 books online.

Prepare an image:

1. If you are going to sysprep Express, extract the source media to the local machine as follows:

SQLEXPR_x64_ENU.exe /x:c:\SQLServer2008R2Express

2. Run Setup.exe from your original source media or from the extracted Express location. When the Installation Center comes up, navigate to the Advanced page and select “Image preparation of a stand-along instance of SQL Server”.

image

 

3. Select OK on the Setup Support Rules, if there are no errors.

image

 

4. Click Install on the Setup Support Files dialog.

image

 

5. Click Next.

image

 

6. Accept the License Terms

image

 

7. Select the features to Sysprep and then click Next. Notice only the Database Engine, Replication, Full-text, and Reporting Services can be Sysprep.

image

 

8. Specify an Instance ID and then click Next

image

 

9. Click Next on the Disk Space dialog.

image 

 

10. Click Next on the Prepare Image Rules, if there are no errors.

image

 

11. Click Prepare to kick off the installation of the files.

image 

 

12. Just wait for the process to continue.

image

 

13. You are now done installing the files. Click Close to exit out of wizard.

image

 

 

Complete or configure the installation:

Important: To complete this configuration, the Wizard needs access to the original source media.

1. Launch the “Complete SQL Server 2008 Installation” short-cut off of the Start menu.

image

 

2. Click OK

image

 

3. Click  Install

image

 

4. Click Next

image

 

5. Enter your Product Key

image

 

6. Accept the License terms and then click Next.

image

 

7. Specify the Instance ID that you want to complete or configure and then click Next.

image

 

8. Click Next on the features to be completed and configured.

image

 

9. Specify an Instance Name and then click next.

image

 

10. Specify the account that the services should run under and then click next.

image

 

11. Specify the accounts that should have admin permission inside of SQL Server

 

image

 

12. Specify how to configure Reporting Services configuration mode

image

 

13. Specify the Error Reporting settings.

image

 

14. Click Next if there are no errors.

image

 

15. Click complete to start the process of configuring the features

image

16. Setup is setting up the instance and services.

image

 

17. Setup is done configuring the features. You can now start using the instance.

image


Comments (17)

  1. Aben says:

    Thanks for this

    Loving the command line options as well… have written two guides

    Sysprep Guide

    wellytonian.com/…/sql-2008-r2-sysprep-and-installation

    Unattended Installation

    wellytonian.com/…/sql-server-2008-r2-unattended-installation

  2. KISHORE says:

    IS GOOD IMAGES SHOWING INISTALATION

  3. Shailesh says:

    How can i set Mix mode authentication at the time of installing Sql Server 2008

  4. mumtaz says:

    Can We Install schema and then sysprep to reuse ?

  5. Luis says:

    Hello if select the default name (MSSQLSEVER) the name of de instance is Equal to name of the NETBIOS neme after syspre process

  6. Dhiraj says:

    Thanks Sir…. for giving such a nice Article… Thanks Again

  7. Victor Vedmich says:

    Guys please fix problem with images. I doesn't see it.

  8. Rahul pal says:

    Pl tell me that  it is important that u first install sql server 2008R2 before visual studio.

    if visual studio already install it create problem

  9. Ashwani Mishra says:

    Hi Plz help me, I am unable to find SQL SERVER Management studio in lapy. I have fallowed all instruction which has above mentioned. I am using win 8. Please help

  10. malik says:

    pls tell me how to connect with sql server with server

  11. aDSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS says:

    WEL'''''''''''''''HHHHHHHHHHHHHHHHHHHHHHHHHHHJNKJKNKNJ

  12. Pramod says:

    Thanks Sir…. for giving such a nice Article.

  13. Pierre says:

    Thanks for this article

    Excatly what we were lookign for 🙂 !

  14. sonu says:

    Hi Friends,

                       How to installation sql server.

  15. Danish says:

    i dont know why my sql server 2008 shortcut is missing in start menu

  16. MUZAMIL says:

    thanks sir well guided!! needed alot this…

  17. Andy Wylie says:

    This is great but one small thing to ask. When you have a sysprepped image that's not domain joined (as recommended) it generates a random name such as WIN-05TBF9B79A4.

    how are you supposed to provide a run as account in the SQL profile properties for SQL to finish up and install the SQL instance?

    It will not accept the image name from the template and you cant use .Administrator so what are you supposed to do?

    I have never been able to get this to work as it fails every time on Error 22738

    The configuration operation for the SQL Server Instance (MSSQLSERVER) could not be completed because the specif Windows account is not valid. Impersonation of the specific Windows account failed. ErrorMessage: The user name or Password is incorrect