Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Cannot generate SSPI Expand / Collapse
Author
Message
Posted Tuesday, August 5, 2008 2:29 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, May 20, 2013 6:07 AM
Points: 78, Visits: 171
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)"
Post #546566
Posted Tuesday, August 5, 2008 2:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 5, 2008 3:22 AM
Points: 1, Visits: 1

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.
Post #546572
Posted Monday, September 24, 2012 1:47 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, September 24, 2012 1:47 PM
Points: 10, Visits: 7
Excelent!!! Thanks!!!
Post #1363705
Posted Saturday, January 19, 2013 11:51 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 4:08 AM
Points: 1,500, Visits: 2,523
.. 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.
Post #1409259
Posted Monday, January 21, 2013 7:42 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 9:30 AM
Points: 469, Visits: 477
recycle SQL also fix the issue, with out changing the service account top local and service account
Post #1409555
Posted Monday, January 21, 2013 9:04 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 4:08 AM
Points: 1,500, Visits: 2,523
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.
Post #1409770
Posted Tuesday, January 22, 2013 1:43 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:03 AM
Points: 5,132, Visits: 4,925
Usually happens when trying to use Kerberos auth but it fails back to NTLM auth
http://support.microsoft.com/kb/811889




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1409862
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse