Deployment Automation::ConfigureSharepointSQLPermissions
This procedure configures SQL Server with permissions for Windows SharePoint Services.
Arguments
Input argument | Description | Required |
---|---|---|
<preferredDomainController> |
The domain controller to use for Active Directory actions. Required input. For example,
|
Yes |
<serverName> |
The name of the SQL server. Required input. For example,
|
Yes |
<username> |
The domain user account specified as the Windows SharePoint Services version 3.0 service account. Required input.For example,
|
Yes |
Sample Code
Example XML Request
<request xmlns:xsl="https://www.w3.org/1999/XSL/Transform">
<data>
</data>
<procedure>
<execute namespace="Deployment Automation" procedure="ConfigureSharepointSQLPermissions" impersonate="1">
<executeData>
<preferredDomainController>ad01.fabrikam.com</preferredDomainController>
<serverName>SQLBE01</serverName>
<username>FABRIKAM\SharePoint_AppID</username>
</executeData>
<after source="executeData" destination="data" />
</execute>
</procedure>
</request>
Manual Procedures
The ConfigureSharepointSQLPermissions procedure automatically performs the following manual steps:
Log on to SQLBE01 as a member of the domain administrators group.
Click Start, point to Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.
At the Connect to Server dialog box, click Connect.
Expand Security, right-click Logins, and then click New Login.
In the Login name box, enter FABRIKAM\SharePoint_AppID (the domain user account specified as the Windows SharePoint Services version 3.0 service account for the Windows SharePoint Services application pool).
Note
To use multiple application pools running as different identities, repeat the previous steps for each domain account that is used as the identity for the application pool.
Verify that Windows Authentication is selected.
In the left pane, click Server Roles.
In the Server Role list, select the dbcreator, processadmin, and securityadmin check boxes, and then click OK.