This post has been sitting in the draft folder for way too long, March of last year to be precise. Â So although this is no […]
Category: SQL Server
SQL Named Instance – Static Port Overrides with SQL Browser
I ran across an issue that I haven’t seen since SQL 2000 and had almost forgotten about. Â Let’s do a quick review of ports in […]
Reinstall SQL Server Performance Counters
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 […]
SSPI Handshake Failed
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 […]
Configure Kerberos for SQL with Virtual Accounts
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 […]
Error Authenticating Proxy | SQL and UPNs
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. […]
Assign SQL Service Account with Group Policy
How do I assign and enforce a service account for the SQL Server Services with Active Directory Group Policy? The answer to this question requires […]
Active Directory and SQL Server Questions Answered
I presented for the PASS DBA Virtual Chapter several weeks ago and talked about different ways that Active Directory can affect your SQL Server. Â We […]
SQL Service Account Recursive Group Membership
It was recently brought to my attention that a post with the script I talk about below could not be found on my blog. Â Either […]
Where I’ll Be
Things have been too quiet here on the blog, but there’s a reason (a few actually). Â This year has been nuts for me, but it’s […]
You must be logged in to post a comment.