December 2, 2009 at 12:55 pm
I am receiving the error - Cannot Generate SSPI Context - when attempting to access a SQL2005 instance using Windows Authentication from my desktop. I can log in with SQL Authentication.
There are 3 instances on this server and I can connect to the other 2 fine. All 3 instances are set to mixed authentication.
Instance 1 is SQL Server 9.0.4035 - Able to use Windows Authentication
Instance 2 is SQL Server 9.0.3068 - Able to use Windows Authentication
Instance 3 is SQL Server 9.0.3068 - Not able to use Windows Authentication
I read through KB811889.
It does not seem that SPN would be a problem since the other 2 instances work.
If I am on the logged into the server Windows Authentication works fine.
All help is appreciated.
December 2, 2009 at 1:24 pm
I have run into this in the past as well (multiple instances on a server but not all produce this error). The SPN Fix described in that KB article worked for us.
I would start with that and see if it fixes your errors.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 4, 2009 at 5:00 am
Checking off the Write servicePrinicpalName box and restarting the SQL Services on the Instance worked. Thanks for your help.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply