December 2, 2010 at 2:52 am
I am more of an hardware person, and my server is runnning the active domain controller and the SQL server, and my small company uses a Sage Pastel for accounting; any time we want to connect to the sage pastel from the client system; it brings back the message 'cannot generate the SSPI context'
Please what can I do, I know the dates and time on the server and clients systems are same. What else can I do.
Please Helpppppp
you can send the answer also to my mail prompt2k2@hotmail.com
December 2, 2010 at 4:45 am
Please go through this article which has lot of options on how to fix this error.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
December 2, 2010 at 11:44 am
Have you by any chance changed the account running the SQL Server service? I have seen this error when the service account changed from one account to another account and the service principle name (spn) for the SQL Server service was not changed.
If you did change the account you can use "setspn -L <old account name>" (look for MSSQLSvc) to verify if the spn is still registered on the old account. If it is, you can fix it by deleting the spn reference by deleting the MSSQLSvc from the account by executing "setspn -D MSSQLSvc/<FQDN>[:<port>]" and registering it on the new account with "setspn -A MSSQLSvc/<FQDN>[:<port>]"
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply