January 2, 2009 at 4:41 am
I am working thru setting up a 3 tier application (client, mid-tier, db) with each tier on a separate system. When I go to setup the service delegation for the mid-tier the SQL Server Service "MSSQLSvc" is not listed in the "Add Services" box. I have verified in the SQL Server Log that the SPN is registered during startup. But an "SPN -L servername" does not list it.
This is a Windows 2008 domain. All servers are running Windows 2008. I am using SQL Server 2008.
This is an isolated testing environment and I am using the domain admin account to run the services. So I don't think this would be a permissions issue.
Any ideas?
January 2, 2009 at 9:50 am
The SPN is going to be registered under the account running SQL Server - not the machine. Use the -Q option to query for the SPN record instead of -L. The -Q option allows for wildcards.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 2, 2009 at 10:06 am
I had the feeling there was something simple that I was overlooking. That solved my issue. The setup notes were a bit misleading. Thanks for the help.
January 2, 2009 at 10:43 am
No problem - glad I could help.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply