August 3, 2008 at 11:55 am
Hi,
Trans log backup on my prod server is now failing with this error below. Pls help..
Microsoft (R) SQLMaint Utility (Unicode), Version [Microsoft SQL-DMO (ODBC SQLState: HY000)] Error 0: [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context
August 3, 2008 at 12:10 pm
Did you change the account that is running SQL Server? For example, change from a domain admin account to a domain service account? Or, from local system to a domain account?
If so, you need to use SETSPN.exe to review the SPN records and remove the old entry and add a new entry for the new domain account.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 5, 2008 at 12:32 pm
thanks for the info...that helped..
August 5, 2008 at 12:44 pm
Great - glad I could help.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply