Fixing Unconstrained Kerberos Delegation
We've recently had an AD audit which has reported that accounts have unconstrained Kerberos delegation.
A number of these are SQL accounts. The delegation setting has appeared due to setting an SPN on the account as follows:
contoso\SQLS0003
MSSQLSvc/server01.contoso.com,MSSQLSvc/server01.contoso.com:1433
If I want to change this to constrained delegation, do I just go into the account properties and set:
"Trust this user for delegation specific services only" Use Kerberos
And select the account itself as a delegated object?