Post reply

Error: Cannot generate SSPI context

  • July 11, 2012 at 9:32 am

    #259450

    Hi All,

    Hope all is well. I am getting the below error when I am trying to connect to SQL Server through SSMS as windows authentication. But I am able to connect to the server if I use sql server authentication or use IP Address instead of server name with with windows authentication. I dont have anything in the SQL Server Error Log to investigate further. Any Ideas?

    Error:

    Cannot generate SSPI context. (Microsoft SQL Server, Error: 0)

    Thanks for your inputs

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • July 11, 2012 at 10:06 am

    #1511668

    Your issue is best explain bu microsoft support at

    http://support.microsoft.com/kb/811889

  • July 11, 2012 at 12:28 pm

    #1511728

    thanks for the reply

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • July 12, 2012 at 3:26 am

    #1511932

    I have faced this problem before.I had application using sytem dsn and changed connection to a file dsn and the error no longer appeared.In some cases restarting could temporarily remove the error.

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

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

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