Karthick PK 's Blog

Karthick PK's technical blog covering topics such as SQLServer troubleshooting, technologies and security.

How to enable Constraint delegation for SQLServer2005

How to enable Constraint delegation for SQLServer2005

Rate This
  • Comments 0

Constraint delegation for SQLServer2005

Follow the below steps to set the constraint delegation for SQLServer2005

1. In active directory users and computers for the startup account of SQLServer
a.Select "Trust this user for delegation to specified services
only"
b.Add host service for each node of the cluster
2. In active directory users and computers for each node under the delegation
tab
a. Select "Trust this computer for specified services only"
b. Add CIFS and Protected storage for each node of the cluster and each DC which
SQLserver may use to authenticate.

Take the SQLServer Group offline in clutser administrator and bring it online.


Please refer the attached document for additional information with Image and example

 

Regards

Karthick PK

 

 

Attachment: Constraint delegation for SQLServer2005.docx
Comments
Leave a Comment
  • Please add 8 and 8 and type the answer here:
  • Post