Post reply

Cannot generate SSPI Context

  • April 19, 2005 at 11:02 am

    #102489

    I am trying to connect to one of our SQL servers via Ent mgr - I cannot access and receive an error, see below. I can only see the server in Ent Mgr if I remote to the server where SQL 2000 resides and run Ent mgr from there.

    The SQL 2000 Named Intance resides on a Windows server 2003

    The error I receive is:

    Cannot generate SSPI Context?

    After i change the SQL Server Service Account, i am getting above error message. I change the service account 5 machines  but i have only problem with one server.

    Please any body help me?

     

  • April 20, 2005 at 7:11 am

    #553768

    I have had this problem connecting via Enterprise Manager using Windows authentication after changing the sql startup account.  It does not always occur and sql server logins still work.

    What I did to resolve this was to reset the SPN on the server by running a command (example below) from C:\Program Files\Support Tools.  (I first had to install these support tools from WindowsServer2003\ENGLISH\WIN2003\STANDARD\SUPPORT\TOOLS\suptools.msi.)

    setspn -A MSSQLSvc/myserver.microsoft.com:1433 sqlsvc

    Please refer to the following article for complete instructions.

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_2gmm.asp

     

  • April 20, 2005 at 10:39 am

    #553842

    Thanks for reply. I will try this weekend.

    Regards

    Ram

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply