none
Cannot generate SSPI context. RRS feed

  • Question

  • We have two front end server and one backup database server.

    I am facing this is error in event viewer of application log from 3 days.

    Unknown SQL Exception 0 occurred. Additional error information from SQL Server is included below.

    Cannot generate SSPI context.

    what is the problem ?

    Wednesday, April 24, 2013 7:39 AM

Answers

  • http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/60cbbf45-2fa8-49c5-8b07-7d919e2fc7e0

    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    Wednesday, April 24, 2013 8:15 AM

All replies

  • Refer the below website..

    http://blogs.technet.com/b/mdegre/archive/2011/01/13/sql-server-2008-connectivity-issue-cannot-generate-sspi-context.aspx


    Regards http:\\sqldbatask.blogspot.com MCTS Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

    Wednesday, April 24, 2013 8:09 AM
  • http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/60cbbf45-2fa8-49c5-8b07-7d919e2fc7e0

    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    Wednesday, April 24, 2013 8:15 AM
  • Hi,

     Apart from what is suggested by Rama you can also see if trust exists between domains (i assume both system are in different domain).

    Thursday, April 25, 2013 11:27 AM
    Moderator
  • The Problem sometime caused by your login is not trusted by domain/may not authenticated or there is time different between your PC and Domain. If the problem still persisted try to connect SQL using other network protocol such as namepipes
    Friday, April 26, 2013 3:44 AM