Skip to content

considerations-for-installing-sql-server-using-sysprep.md

Latest commit

 

History

History
98 lines (64 loc) · 8.27 KB

considerations-for-installing-sql-server-using-sysprep.md

File metadata and controls

98 lines (64 loc) · 8.27 KB
title Considerations for Installing SQL Server Using SysPrep | Microsoft Docs
ms.custom
ms.date 09/05/2017
ms.prod sql-non-specified
ms.prod_service database-engine
ms.service
ms.component install-windows
ms.reviewer
ms.suite sql
ms.technology
setup-install
ms.tgt_pltfrm
ms.topic article
ms.assetid e1792eeb-2874-4653-b20e-3063f4eb4e5d
caps.latest.revision 22
author MikeRayMSFT
ms.author mikeray
manager jhubbard

Considerations for Installing SQL Server Using SysPrep

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] [!INCLUDEssNoVersion] SysPrep allows you to prepare a stand-alone instance of [!INCLUDEssNoVersion] on a computer and to complete the configuration at a later time. [!INCLUDEssNoVersion] SysPrep involves a two-step process to get to a configured stand-alone instance of [!INCLUDEssNoVersion]. The steps include the following:

  • Prepare Image

    This step stops the installation process after the product binaries are installed, without configuring the computer, network, or account-specific information for the instance of [!INCLUDEssNoVersion] that is being prepared.

  • Complete Image

    This step enables you to complete the configuration of a prepared instance of [!INCLUDEssNoVersion]. During this step, you can provide the computer, network, and account-specific information.

For more information about how to install [!INCLUDEssNoVersion] using SysPrep, see Install SQL Server Using SysPrep.

Common Uses for [!INCLUDEssNoVersion] SysPrep

You can use the [!INCLUDEssNoVersion] SysPrep capability in any of the following ways:

  • By using the Prepare Image step, you can prepare one or more unconfigured instances of [!INCLUDEssNoVersion] on the same computer. You can configure these prepared instances by using the Complete Image step on the same computer.

  • You can capture the [!INCLUDEssNoVersion] Setup configuration file of the prepared instance and use it to prepare additional unconfigured [!INCLUDEssNoVersion] instances on multiple computers for later configuration.

  • In combination with the Windows System Preparation tool (also known as Windows SysPrep); you can create an image of the operating system including the unconfigured prepared instances of [!INCLUDEssNoVersion] on the source computer. You can then deploy the operating system image to multiple computers. After you complete the configuration of the operating system, you can configure the prepared instances by using the Complete Image step of [!INCLUDEssNoVersion] Setup.

    The Windows SysPrep tool is used to prepare Windows operating system images. It is used to capture a customized image of the operating system for deployment throughout an organization. For more information about SysPrep and its uses, see SysPrep.

Installation Media Considerations

If you are using a full version of [!INCLUDEssNoVersion], consider the following:

  • Non-Express editions of [!INCLUDEssNoVersion]:

    • The Prepare Image step uses [!INCLUDEssNoVersion] Evaluation edition to install the product binaries. When the instance is completed, the edition of [!INCLUDEssNoVersion] depends on the product ID provided during the complete image step.

    • If you provide an Evaluation edition product ID, the evaluation period is set to expire 180 days after the prepared instance is completed.

  • Express editions of [!INCLUDEssNoVersion]:

    • To prepare an instance of [!INCLUDEssNoVersion] Express editions, use the Express installation media.

    • You cannot specify Product IDs for a prepared instance of [!INCLUDEssNoVersion] Express editions.

Supported [!INCLUDEssNoVersion] Installations

SysPrep in [!INCLUDEssCurrent] supports all features, including tools, of [!INCLUDEssNoVersion].

You can prepare multiple instances for side-by-side installations of [!INCLUDEssCurrent] or earlier versions. The features of these instances must support SysPrep.

The [!INCLUDEssNoVersion] Native Client is automatically installed and completed at the end of the prepare image step.

[!INCLUDEssNoVersion] Browser and [!INCLUDEssNoVersion] Writer are automatically prepared when you prepare an instance of [!INCLUDEssNoVersion]. They are completed when you complete the [!INCLUDEssNoVersion] instance by using the Complete Image step.

For information about supported editions of [!INCLUDEssNoVersion], see Editions and supported features of SQL Server 2017.

You can perform an edition upgrade while configuring a prepared instance of [!INCLUDEssNoVersion]. This option is not supported for [!INCLUDEssNoVersion] Express editions.

Beginning in [!INCLUDEssSQL14], [!INCLUDEssNoVersion] SysPrep supports [!INCLUDEssNoVersion] failover cluster installations from the command line.

[!INCLUDEssNoVersion] SysPrep Limitations

Repairing a prepared instance is not supported. If Setup fails during the Prepare Image or Complete Image step, you must run uninstall.

Prepare Image

The Prepare Image step installs the [!INCLUDEssNoVersion] product and features but does not configure the installation.

The [!INCLUDEssNoVersion] features to be installed and the installation location for [!INCLUDEssNoVersion] product installation files can be specified during this step. You can prepare an instance of [!INCLUDEssNoVersion] either through the Image Preparation of a stand-alone instance for SysPrep deployment on the Advanced page of the Installation Center or from the command prompt.

  • You can prepare multiple instances of [!INCLUDEssNoVersion] on the same computer that can be completed later.

  • You can add or remove features that are supported for SysPrep installations from the existing prepared instances of [!INCLUDEssNoVersion].

After the instance is prepared, a shortcut on the Start menu becomes available to complete the configuration of the prepared instance of [!INCLUDEssNoVersion].

Complete Image

You can complete the prepared instances of [!INCLUDEssNoVersion] by using either of the following methods:

  • Use the shortcut on the Start menu.

  • Access the Image completion of a prepared stand-alone instance step on the Advanced page of the Installation Center.

See Also

Planning a SQL Server Installation