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,

  Copy Code 
<preferredDomainController>AD01.Fabrikam.com</preferredDomainController>

Yes

<serverName>

The name of the SQL server. Required input. For example,

  Copy Code 
<serverName>SQLBE01</serverName>

Yes

<username>

The domain user account specified as the Windows SharePoint Services version 3.0 service account. Required input.For example,

  Copy Code 
<username>FABRIKAM\SharePoint_AppID</username>

Yes

Sample Code

Example XML Request

  Copy Code 
<request xmlns:xsl="http://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:

  1. Log on to SQLBE01 as a member of the domain administrators group.
  2. Click Start, point to Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.
  3. At the Connect to Server dialog box, click Connect.
  4. Expand Security, right-click Logins, and then click New Login.
  5. 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.
  6. Verify that Windows Authentication is selected.
  7. In the left pane, click Server Roles.
  8. In the Server Role list, select the dbcreator, processadmin, and securityadmin check boxes, and then click OK.