SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 SSPI Context Issue
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Jim77
Constraint Violating Yak Guru

United Kingdom
440 Posts

Posted - 03/03/2006 :  05:24:59  Show Profile
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

Edited by - Jim77 on 03/03/2006 05:25:59

activecrypt
Posting Yak Master

Germany
165 Posts

Posted - 03/04/2006 :  00:42:19  Show Profile  Visit activecrypt's Homepage  Send activecrypt a Yahoo! Message
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
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.42 seconds. Powered By: Snitz Forums 2000