Kerberos, SPN for SQL Server: Which service account?
Hi,
We have SSRS running as "mydomain\ssrs_svc" and SQL2008 running as "mydomain\sql_svc". SQL2008 is running as the default instance on "sqlbox"
To set up SPNs for Kerberos, what should be command for the SPN for SQL2008?
Is it
setspn -a MSSQLSvc/sqlbox:1433 mydomain\ssrs_svc
or
setspn -a MSSQLSvc/sqlbox:1433 mydomain\sql_svc
Te link below says that the first option above is correct. It says "it does not matter which account SQL Server is running under"
http://callumhibbert.blogspot.com/2009/02/kerberos-delegation-and-sql-reporting.html
On the other hand, MS documentation is sort of vague about this and implies that second option above is correct.
http://download.microsoft.com/download/B/E/1/BE1AABB3-6ED8-4C3C-AF91-448AB733B1AF/SSRSKerberos.docx
None of the options work for me at the moment
setspn -a MSSQLSvc/sqlbox:1433 mydomain\ssrs_svc
produces
"The Kerberos client received a KRB_AP_ERR_MODIFIED error from the server
sql_svc.....This can occur when the target server principal name (SPN) is registered on an account other than the account the target service is using. Please ensure that the target SPN is registered on, and only registered
on, the account used by the server. "
setspn -a MSSQLSvc/sqlbox:1433 mydomain\sql_svc
produces
"KDC_ERR_BADOPTION"
November 22nd, 2010 2:53am