June 3, 2013 at 5:01 am
Hi
We just migrated our windows 2003 server to a new domain. We created a new service account and set the sql services to start under the new domain account (through configuration). SQL server and all services are running just fine. If I am on the server itself, I can connect using Windows authentication from SSMS, but if I am on my client machine (both my user and machine were already on the new domain), I can only connect via SSMS using a sql login (sa).
I get an "cannot generte SSPI context" error. Googling that has not given me any useful clues.
Can anyone please help?
Many thanks
Bex
June 4, 2013 at 6:07 am
Generally that error means that something is not set up right in your new domain. For instance, the only occasions I can recall seeing it are when the DNS server on the client machine was set incorrectly--Active Directory uses DNS to find the servers on the domain, and if the DNS server it's configured to use returns the wrong values, it will cause errors like this. No idea if that's the specific problem in your case, but it's definitely worth checking.
June 4, 2013 at 12:57 pm
Thank you. Our network guy has been out, but back tomorrow, so I'll ask him to check.
Appreciated!
Bex
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply