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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Cannot generate SSPI context

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-04-18 : 10:59:28
Suhas writes "I have a SQL Server installed on a Windows 2000 domain, but not on the domain controller. When I try to access the SQL Server from another machine (the client machine), I get an error "Cannot Generate SSPI Context". I have checked that when I try to connect using named pipes, I do not get this error. This error is thrown when I try to connect using TCP/IP only. Neither do I get this error when trying to connect from the machine that has the SQL Server installed. What could be the reason for this error?"

Krankensteins
Starting Member

24 Posts

Posted - 2006-04-18 : 13:11:03
If i coretly remember then you nid service pack 3 on Windows server. Else You can try conect on client machine in ODBC choise server IP not name.
Go to Top of Page

suhde76
Starting Member

10 Posts

Posted - 2006-04-18 : 19:09:43
That's not what I was looking for. Check out the article http://support.microsoft.com/?id=811889 for details.

Thanks, Suhas, MS SQL Server Engineer, Microsoft.
Go to Top of Page
   

- Advertisement -