Cannot generate SSPI

  • sanjeev_krs2004

    Default port

    Points: 1462

    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)"

  • indu_teja

    SSC Journeyman

    Points: 77

    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.

  • marles

    Valued Member

    Points: 68

    Excelent!!! Thanks!!!

  • Joy Smith San

    SSC-Insane

    Points: 24877

    .. 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.

  • RK Mandava

    SSCarpal Tunnel

    Points: 4153

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

  • Joy Smith San

    SSC-Insane

    Points: 24877

    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.

  • anthony.green

    SSC Guru

    Points: 112515

    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 7 (of 7 total)

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