Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 1

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...

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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