Install SQL Server 2012 Using SysPrep
When installing SQL Server, the Advanced page of the SQL Server Installation Center has two options for preparing a SQL Server install. Using these options allows us to prepare a stand-alone instance of SQL Server and to complete the configuration at a later time. SQL Server SysPrep involves a two-step process to get to a configured stand-alone instance of SQL Server:
- Image preparation of a stand-alone instance of SQL Server
- Image completion of a prepared stand-alone instance of SQL Server
Image PreparationThis step stops the installation process after the product binaries are installed, without configuring the instance of SQL Server that is being prepared. The only features that can be selected during SysPrep installations are the Database Engine and Reporting Services Native Mode. SQL Server Browser and SQL Server Writer are automatically prepared. These are then completed when you complete the SQL Server install by using the Complete Image step. After the completion of the image preparation step, SQL Server is not in a state that it can be used.
Image CompletionThis step enables you to complete the configuration of a prepared instance of SQL Server. After this step, the instance is ready to be used.
Prepare Image for SQL Server 2012 Using SysPrepTo get started, click on the SQL Server 2012 setup.exe. In the SQL Server Installation Center, navigate to the Advanced page and select "Image preparation of a stand-along instance of SQL Server". Select OK on the Setup Support Rules, if there are no errors.
Complete Installation for SQL Server 2012 Using SysPrepAfter you go through the prepare stages you will now have another option in the Start menu to complete the installation. To run the complete process, go to Start > Program Files > Microsoft SQL Server 2012 > Complete SQL Server Installation as shown below.
If we want to install another instance on this same server we can run through the Complete Installation steps and create a new named instance and change the parameters where needed.
Use for SQL Server SysPrep
- We can prepare one or more unconfigured instances of SQL Server. Each configuration can have different options.
- We can capture the SQL Server Setup configuration file of a prepared instance and use it to prepare additional unconfigured SQL Server instances on multiple computers for later configuration.
- In combination with the Windows System Preparation tool (also known as Windows SysPrep); we can create an image of the operating system including the unconfigured prepared instances of SQL Server on the source computer. Later on we can deploy the operating system image to multiple computers. After completing the configuration of the operating system, we can configure the prepared instances by using the Complete Image step for the SQL Server setup.
- Only the database engine and reporting services are supported by SysPrep.
- It cannot be used for clustering
- It is not supported on IA64 system or supported in WOW64.
- The installation media needs to be available when preparing an image and configuring the image. When using SysPrep for SQL Server Express, we need to extract the files to the local machine before preparing the image.