Post reply

Cannot generate SSPI

  • August 5, 2008 at 2:29 am

    #123656

    Error message shown in the logs is :

    Approva.ApplicationBlocks.ExceptionManagement.BaseApplicationException: Error occurred in Openconnection in SQLServer. ---> System.Data.SqlClient.SqlException: Cannot generate SSPI context.

    at System.Data.SqlClient.SqlInternalConnection.OpenAndLogin()

    at System.Data.SqlClient.SqlInternalConnection..ctor(SqlConnection connection, SqlConnectionString connectionOptions)

    at System.Data.SqlClient.SqlConnection.Open()

    at Approva.BizRights.Core.DBSQLServer.SQLServer.OpenConnection(String i_sConnectionString)

    --- End of inner exception stack trace ---

    at Approva.BizRights.Core.DBSQLServer.SQLServer.OpenConnection(String i_sConnectionString)

    at Approva.BizRights.Core.DatabaseImplementation.Database.Connect(Boolean i_bUseXML)

    --- End of inner exception stack trace ---

    at Approva.BizRights.Core.DatabaseImplementation.Database.Connect(Boolean i_bUseXML)

    at Approva.BizRights.ApprovalServiceOperations.ApprovalRequestOperationsManager.MonitorDraftRequests(Object o)"

  • August 5, 2008 at 2:47 am

    #853051

    If you get this "SSPI Context Error".

    The issues we face are:-

    1. We will not be able to connect to SQL Server remotely.

    2. How ever we will connect to server with local account.

    CAUSE: The issue might be becasue of no proper sync happenign fro the SPNs in Active directory.

    RESOLUTION:

    1. You need to reset SPN.use the synytax "SET SPN" u can check the syntax in net once.

    2. change your sql server service account from domain account to Local account recycle sql and the n reset again with your domain account and recycel sql server.

    hope this resolves.

  • September 24, 2012 at 1:47 pm

    #1541590

    Excelent!!! Thanks!!!

  • January 19, 2013 at 11:51 pm

    #1579012

    .. I know it's pretty old post..

    Did the above solution work for anyone else here ?

    Asked since we are facing this issue on one of the remote server which is not managed by us and we don't sufficient rights too ofcourse. Just wanted to give some suggestions to the responsible DBAs at remote location.

    Thanks in advance.

  • January 21, 2013 at 7:42 am

    #1579252

    recycle SQL also fix the issue, with out changing the service account top local and service account

  • January 21, 2013 at 9:04 pm

    #1579427

    rajkumarmandava (1/21/2013)

    recycle SQL also fix the issue, with out changing the service account top local and service account

    Do you mean RESTART ing SQL will solve the issue ? No, it doesn't fix the problem in our scenario.

  • January 22, 2013 at 1:43 am

    #1579484

    Usually happens when trying to use Kerberos auth but it fails back to NTLM auth

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

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

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