February 24, 2013 at 10:02 am
I have SQL 2008 r2 installed on Win 2003 server. Using 2008/R2 management studio on WinXP client to connect to sql server using Windows authenication works fine. However, when trying to connect from a Windows 7 client with 2008/R2 management studio, I get this error everytime; "Cannot generate SSPI context".
I have searched hi and low for the solution, and have read many articles (Microsoft MSDN, etc.), including one that I found here on SQL Server Central. However I have not found anything with regards to using Window 7 connection errors. Since everything works from Windows XP, I would tend to think that is is a security issue in Windows 7.
Does anyone have any ideas/thoughts, or suggestions on what I could try?
February 24, 2013 at 11:44 am
are sql services running as a domain account or as localsystem? are you using the actual host name to connect or a CNAME or A-record? what happens if you (ping -t) the host? do you get a different host name?
are the error logs on the OS or SQL Server helpful?
February 24, 2013 at 12:41 pm
I can ping the host fine. The host uses static IP. I can ping -a and get the host name.
I created a service account for SQL on my DC and am using it for SQL services.
I am using the Host Name to connect.
February 24, 2013 at 12:56 pm
for troubleshooting, run the SQL services as localsystem and see if you continue to have issues.
see the following:
- http://simonsql.com/2011/04/26/how-to-troubleshoot-the-cannot-generate-sspi-context-error-message/
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply