Monthly Archives: April 2011

Error: “Cannot generate SSPI context” when connect to a SQL Server instance after service account change

I’ve recently encountered this problem because to update our security standards, all SQL Server service accounts have to be changed to normal domain user accounts. And after changing them from┬áLocalSystem┬áto new accounts, this error starts to pop up. The cause … Continue reading

Posted in SQL Server | Tagged , | Leave a comment

How to Connect to SQL Server Configuration Manager Remotely

Very neat approach which I didn’t know up until today. Here is the link from Microsoft. However, I am still struggling with a server where either local or remote configuration manager fail to report correct statuses of all SQL Server … Continue reading

Posted in SQL Server | Tagged , | Leave a comment