Cannot Generate SSPI Context Error

It’s one of the most frustrating errors I’ve ever encountered. When you try to connect to a SQL Server using Windows Authentication, you can a “Cannot generate SSPI context” error. If you Google this, you’ll find the most common cause is that SQL cannot generate a Service Principle Name (SPN). This usually happens when SQL […]

How To Apply Service Packs To SQL Servers Involved In Mirroring

I recently had to apply SQL Server 2008 SP2 to some of our SQL Servers, three of which are involved in a database mirroring configuration (as the principle, mirror, and monitor servers). Or so I thought. When I looked a bit deeper, I realized I mis-read my spreadsheet and the servers using mirroring were running […]