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 SQLServera.Select "Trust this user for delegation to specified services only"b.Add host service for each node of the cluster2. In active directory users and computers for each node under the delegation taba. 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