A SQL Server profile allows you to configure a sysprepped instance of SQL Server 2008 R2, SQL Server 2012, or SQL Server 2014 for deployment through VMM. You use SQL Server profiles when deploying VMs that are part of a service. The SQL Server profile configures SQL Server according to the profile settings.
To configure a SQL Server profile, perform the following steps:
1. In the Library workspace of the VMM console, right-click the Profiles node, and click Create SQL Server Profile.
2. On the General page of the New SQL Server Profile dialog box, provide a name for the SQL Server profile.
3. On the SQL Server Configuration page, click Add SQL Server Deployment, and provide the following information, as shown in Figure 1.
FIGURE 1 SQL Deployment
- Name Name for the SQL Server deployment.
- Instance Name The instance name. If left blank, it will use the default name MSSQLSERVER.
- Instance ID The instance ID used when you sysprepped the SQL instance.
- Installation Run As Account Account with the permission to deploy SQL Server.
- Media Source Location of the SQL Server installation media, such as a VMM Library share.
- SQL Server Administrators Users or groups that will be configured as SQL Server Administrators. You must specify at least one account.
- Security Mode Select Windows or SQL Server authentication.
- Service accounts Configuration for the SQL Server service, SQL Server agent, and Reporting Services service accounts. You must select a Run As account for all three services.
