Post reply

Cannot generate SSPI context

  • July 17, 2008 at 1:36 pm

    #122566

    Hi All,

    When I tried to connect my SQL Server Enterprise Manager, it is giving error "Could not connect to SQL Server"

    Reason: Cannot generate SSPI context

    I am using windows authentication.

    but when I tried to connect using Sa it is not giving any error and I can connect to the EM successfully.

    Please help me regarding this

    Thanks in advance

    Raghavender Chavva

    Thank You.

    Regards,
    Raghavender Chavva

  • July 17, 2008 at 2:06 pm

    #844648

    In the "connect to Server" Dialog Box Click on Options and choose "Named Pipes" from Network Protocols.. click connect.

    This is using Windows Authen.

    Try this

    Maninder
    www.dbanation.com

  • July 17, 2008 at 2:22 pm

    #844661

    Sorry,

    I can't understand you ?

    can you please brief it ?

    my sql server is named instance which is in my local system only, when I tried to expand the instance the error generated, it is ok till today morning, dont know what happened in between.

    Thank You.

    Regards,
    Raghavender Chavva

  • July 17, 2008 at 2:51 pm

    #844673

    First thing you need to do is check the SPN record for that instance of SQL Server. If you do not have access to this, talk to the network folks and have them find the offending SPN record.

    If the SPN record is tied to a different account from the account running that instance of SQL Server, then you need to remove the wrong SPN record and add it back in for the correct user.

    You can review the following articles for more information:

    http://www.sqlservercentral.com/articles/Installation/cannotgeneratesspicontext/929/

    http://support.microsoft.com/default.aspx?scid=kb;en-us;811889

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • July 17, 2008 at 3:12 pm

    #844685

    When you try to connect to a SQL Server using SQL Server Management Studio, you get a connect to server window.

    In that window there is another button on the Bottom right "options" Click on that and then use Named Pipes Protocol from the Network Prototol Drop Down List.

    Maninder
    www.dbanation.com

  • July 17, 2008 at 4:44 pm

    #844717

    I am using SQL Server 2000 not 2005

    Thank You.

    Regards,
    Raghavender Chavva

  • July 17, 2008 at 9:30 pm

    #844756

    Raghavender (7/17/2008)

    I am using SQL Server 2000 not 2005

    Then you have posted in the wrong forum. You should have posted here:

    http://www.sqlservercentral.com/Forums/Forum5-1.aspx

    I would look at the SPN, as mentioned above. If it's not there, get it created.


    Scott Duncan

    MARCUS. Why dost thou laugh? It fits not with this hour.
    TITUS. Why, I have not another tear to shed;
    --Titus Andronicus, William Shakespeare

  • July 17, 2008 at 11:36 pm

    #844783

    [font="Verdana"]I agree with Jeffery :).. Setting SPN will solve the problem, coz the connection will use Kerberos authentication.[/font]

    Regards..Vidhya Sagar
    SQL-Articles

Viewing 8 posts - 1 through 7 (of 7 total)

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