How to Create a SQL Server Profile in a Service Deployment

 

Updated: May 13, 2016

Applies To: System Center 2012 SP1 - Virtual Machine Manager, System Center 2012 R2 Virtual Machine Manager, System Center 2012 - Virtual Machine Manager

You can use the following procedure to create a SQL Server profile in Virtual Machine Manager (VMM). The SQL Server profile provides instructions for installing an instance of Microsoft SQL Server on a virtual machine.

Important

You can only use a SQL Server profile when you want to deploy a virtual machine as part of a service. In addition, you must use a virtual hard disk that contains a prepared instance of SQL Server (generalized by using the Sysprep tool), as described in the following list:

  • For VMM in System Center 2012: SQL Server 2008 R2.
  • For VMM in System Center 2012 Service Pack 1 (SP1): SQL Server 2008 R2 or SQL Server 2012.
  • For VMM in System Center 2012 R2: SQL Server 2008 R2 or SQL Server 2012.

To create a SQL Server profile

  1. Open the Library workspace.

  2. On the Home tab, in the Create group, click Create, and then click SQL Server Profile.

    The New SQL Server Profile dialog box opens.

  3. On the General tab, in the Name box, enter a name for the SQL Server profile. For example, enter Corporate Finance SQL Server.

  4. Click the SQL Server Configuration tab, and then, next to Add, click SQL Server Deployment.

    Note

    A SQL Server deployment corresponds to the configuration of one instance of SQL Server. If you want to configure multiple instances of SQL Server on the same virtual machine, you must add and configure a SQL Server deployment for each instance.

  5. Under SQL Server Deployment, do the following:

    1. Click SQL Server Deployment, Deployment 1. In the results pane, enter the required configuration information.

      Required information includes the name of this SQL Server deployment (for which you can choose to enter a more meaningful name than "Deployment 1"), the SQL Server instance name, and the SQL Server instance ID (the instance ID specified during installation of SQL Server). The installation Run As account is optional and uses the VMM Service account unless you specify otherwise. For more information about Run As accounts, see Configuring Run As Accounts in VMM.

    2. Click Configuration. In the results pane, enter the required configuration information.

      Required information includes the media source (the path to the SQL Server installation media folder where Setup.exe is located) and the SQL Server administrators.

    3. Click Service Accounts. In the results pane, enter the Run As accounts to use.

    After you have made your selections, click OK.

  6. To verify that the profile was created, in the Library pane, expand Profiles, and then click SQL Server Profiles.

    The SQL Server profile appears in the Profiles pane.

See Also

Creating Profiles and Templates in VMM
Preparing to Create Services in VMM
Creating Service Templates in VMM