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
 Old Forums
 CLOSED - General SQL Server
 SSPI Context Issue

Author  Topic 

Jim77
Constraint Violating Yak Guru

440 Posts

Posted - 2006-03-03 : 05:24:59
Hi there guys
I am getting a strange error message when I try to log into one of my remote servers from Enterprise Manager
I get theis error message :

---------------------------
SQL Server Enterprise Manager
---------------------------
A connection could not be established to JY2003SMEM010.

Reason: Cannot generate SSPI context.

Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the JY2003SMEM010 node) and try again.
---------------------------
OK
---------------------------

Although when I remote desktop in to the local default instance that I am trying to access remotly the server is running and everything is functioning normally.

any suggestions would be appreciatted
cheers

jim

activecrypt
Posting Yak Master

165 Posts

Posted - 2006-03-04 : 00:42:19
Hi,
refer below KBs :
http://support.microsoft.com/?id=811889

http://support.microsoft.com/?id=814401

http://www.sqlservercentral.com/columnists/cmiller/cannotgeneratesspicontext.asp


Regards

Andy Davis
Sql Shield Team
--------------------------------------------
SQL Server Encryption Software
http://www.sql-shield.com
Go to Top of Page
   

- Advertisement -