up vote 0 down vote favorite
share [g+] share [fb]

In my organization I have the following network scenario:

A Windows 2003 SP2 server box with Active Directory enabled The server also has an installation of SQL Server 2000 (Service Pack 4)

5-6 Windows XP SP2 clients having Visual Studio 2008 installed on them. We also have SQL Server 2000 clients on these XP machines. Whenever a user is working in Enterprise Manager, the connection to the server is broken with the error message "Cannot generate SSPI context". This also happens when we are debugging programs using Visual Studio 2008.

We have set the Network Connection properties to TCP/IP followed by Named Pipes. What else needs to be done as this error does not seem to go away.

I do not know if this is the right place to ask this question or to try stackoverflow (sister website) as this question seems to be integrated with OS and database settings.

Any help would be highly appreciated.

link|improve this question
When you say that the connection is broken when using EM, do you mean the EM connection or the VS2008 connection(s)? I think you're saying EM but I just want to clarify. – squillman Jul 28 '09 at 13:45
I am talking about EM of SQL Server 2000. BTW under which name is the SQL Server Service account visible in the Services Management Console on the client machine. – Vinod Aug 5 '09 at 8:24
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard