Post reply

How to troubleshoot: "Cannot generate SSPI Context"

  • May 23, 2007 at 8:22 am

    #68419

    Hi,

    I have SQL Server 2005 installed on my machine.

    Also I have a server named SQLApp4 running SQL Server 2005.

    When I login to server using my credentials, I am able to connect database engine of SQLApp4 using SQL Server Management Studio installed on SQLApp4.

    But when I try to connect to SQLApp4 database engine from my local machine's SQL Server Management Studio, I get the following error: "Cannot generate SSPI Context".

    Pls advise.

    Regards,

    RSINGH

  • May 23, 2007 at 8:42 am

    #708351

    These can be hard to troubleshoot. It's an issue with the service account running SQL Server not being able to validate credentials. The service might not have an SPN in the Active Directory either.

    Search SSPN here and look for SETSPN.exe on Google.

  • May 24, 2007 at 2:45 am

    #708560

    I've had this issue before and it was a problem with the DNS server setup on my local machine i.e. my local machine couldn't reach it's primary DNS.

    Don't know if this helps at all but thought I'd throw it in anyway.

    Dan
    www.firstcs.co.uk

  • May 24, 2007 at 2:58 pm

    #708801

    This may help http://support.microsoft.com/kb/843248/en-us 

  • May 24, 2007 at 3:55 pm

    #708809

    Thank you all.

    The problem was resolved by adding an SPN for the account under which the MSSQLServer service was running. Following command was used:

    setspn -A MSSQLSvc/<ServerName>.<domain>:1433  <AccountName>

    Thanks,

    RSingh

Viewing 5 posts - 1 through 4 (of 4 total)

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