Archives: February 2014
I’ve had several instances over the last few months where I had to reinstall the SQL Server Performance Counters. It sounds odd to have them magically disappear, but I’ve found a 3rd party monitoring product to be the culprit.
First we need to unload the counters just to make sure… Read more
A fellow community member sent me an email saying he was having trouble authenticating with Kerberos. Here is the error he was receiving:
SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error… Read more
At a conference recently I had someone ask how they would configure Kerberos for accounts that look like “NT Service\MSSQLServer” or “NT Service\MSSQL$MyInstance”. Please note that these are NOT the built-in system accounts, even though they look similar. The system accounts are “Local System”, “Local Service”, and “Network Service”. The… Read more
Have you ever had an error when using a SQL Server Proxy Account? I ran across a misleading error. Let me qualify that a little. It wasn’t misleading in the sense of it saying one thing and meaning another. It was misleading because it’s one of those errors you see… Read more