Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shehz
Starting Member
10 Posts |
 Posted - 2007-02-05 : 18:22:35
|
| All of a sudden I cannot connect to sql server from Visual Studio. Nor I can't conenct to Sql server through IIS and it gives me the same error saying "Login failed: Cannot Generate SSPI Context". Lots of my development projects got stuck because of the SSPI Issue. I know there was a network upgrade from Windows NT (users) to Active directory. I can only access the sql server from the host machine.if someone can guide or give me a quick run down on things to look for that would be wonderful. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-05 : 18:31:55
|
| Windows Authentication is messed up on the clients. Have them reboot to fix.Tara Kizer |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2007-02-07 : 08:11:16
|
| Also find out if anyone recently changed their passwords. Any sessions that were open while the password was changed will often fail because they cannot authenticate with the old password anymore. This is especially true if their logins are used to run Windows services, scheduled tasks, or SQL Server jobs. |
|
|
|
|
|
|
Cannot Generate SSPI Context