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 […]
Today, I embark on a new adventure – I’m starting at a new company. I’ve left a company where I was the sole DBA managing about 15 SQL Servers and going to one where I will be one of two DBAs managing approximately 600 servers. I’m excited about the challenges managing so many servers will […]
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 […]