InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 20:23:37 GMT20http://www.sqlservercentral.com/Forums/Topic546566-146-1.aspxUsually happens when trying to use Kerberos auth but it fails back to NTLM auth[url]http://support.microsoft.com/kb/811889[/url]Tue, 22 Jan 2013 01:43:35 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic546566-146-1.aspx[quote][b]rajkumarmandava (1/21/2013)[/b][hr]recycle SQL also fix the issue, with out changing the service account top local and service account[/quote]Do you mean RESTART ing SQL will solve the issue ? No, it doesn't fix the problem in our scenario.Mon, 21 Jan 2013 21:04:48 GMTJoy Smith Sanhttp://www.sqlservercentral.com/Forums/Topic546566-146-1.aspxrecycle SQL also fix the issue, with out changing the service account top local and service accountMon, 21 Jan 2013 07:42:33 GMTrajkumarmandavahttp://www.sqlservercentral.com/Forums/Topic546566-146-1.aspx.. 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.Sat, 19 Jan 2013 23:51:47 GMTJoy Smith Sanhttp://www.sqlservercentral.com/Forums/Topic546566-146-1.aspxExcelent!!! Thanks!!!Mon, 24 Sep 2012 13:47:25 GMTmarleshttp://www.sqlservercentral.com/Forums/Topic546566-146-1.aspxIf 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.Tue, 05 Aug 2008 02:47:36 GMTindu_tejahttp://www.sqlservercentral.com/Forums/Topic546566-146-1.aspxError 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)"Tue, 05 Aug 2008 02:29:28 GMTsanjeev_krs2004