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.
To enable delegation for all computers that are running SQL Server
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
Other Resources
How to Configure the Service Principal Name