I can log into SQL Server Management Studio with a SQL Server Authentication login and password, but when trying to log in with Windows Authentication I get this error:

"Cannot generate SSPI context. (.Net SqlClient Data Provider)"

What is going on here?

See #6 here: http://blogs.msdn.com/sql_protocols/archive/2006/12/02/understanding-kerberos-and-ntlm-authentication-in-sql-server-connections.aspx

This is a little more complicated: http://support.microsoft.com/kb/811889/

But I think either will get you on the right track.

p.s. This might be better posted on ServerFault...

Your Answer

 

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.