How to Create a SQL Server Profile in a Service Deployment
Updated: January 15, 2013
Applies To: System Center 2012 - Virtual Machine Manager, System Center 2012 SP1 - 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 SQL Server on a virtual machine.
|You can only use a SQL Server profile when you want to deploy a virtual machine as part of a service. Also, you must be using a virtual machine that contains a sysprepped version of SQL Server. For VMM in System Center 2012, the version must be SQL Server 2008 R2. For VMM in System Center 2012 Service Pack 1 (SP1), the version can be either SQL Server 2008 R2 or SQL Server 2012.|
To create a SQL Server profile
Open the Library workspace.
On the Home tab, in the Create group, click Create, and then click SQL Server Profile.
The New SQL Server Profile dialog box opens.
On the General tab, in the Name box, enter a name for the SQL Server profile. For example, enter Corporate Finance SQL Server.
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.
Under SQL Server Deployment, do the following:
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 (you may choose to enter a more meaningful name than “Deployment 1”), the SQL Server instance name, and the SQL Server instance ID (specified during your SQL Server installation). The installation Run As account is optional and uses the VMM Service account unless otherwise specified. For more information about Run As accounts, see Configuring Run As Accounts in VMM.
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.
Click Service Accounts. In the results pane, enter the Run As accounts to use.
After you have made your selections, click OK.
- Click SQL Server Deployment, Deployment 1. In the results pane, enter the required configuration information.
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.
For additional resources, see Information and Support for System Center 2012.
Tip: Use this query to find online documentation in the TechNet Library for System Center 2012. For instructions and examples, see Search the System Center 2012 Documentation Library.