How to Enable Delegation for All Computers Running SQL Server

Enable the computers that are running SQL Server for delegation on the domain control servers.

Click Start, point to All Programs, point to Administrative Tools, and then click Active Directory Users and Computers.
In the Active Directory Users and Computers window, in the tree structure, expand <domain name>, and then click Computers.
In the Computers pane, right-click the first SQL Server, and then click Properties.
In the Properties dialog box, on the General tab, select Trust computer for delegation, and then click OK.
Enabling delegation for the SQL server is finished. Repeat these steps for each web facing SQL Server.

Note

This step is not necessary for the Data Warehouse or Staging environment SQL Servers.

See Also