SQL Server
-
Cannot Failover Nodes Using TempDB on Local Storage
I ran into an interesting issue while installing SQL 2012 SP1 in a failover cluster configuration and utilizing the local TempDB feature. If you are unfamiliar with the new feature in SQL 2012 that allows you store TempDB on a local drive in a failover cluster you can read more here. Here is a screen…
-
Central Management Server White Paper
Below is a link to a white paper I wrote on Central Management Server. This white paper is an excellent guide for those who have never used it before. It walks you through how to use CMS from beginning to end. Here is what you can expect to learn: Where to find CMS in management…
-
Policy Based Management White Paper
Below is a link to a white paper I wrote on Policy Based Management. It serves as a guide to not only explain the technology but also walk you through setting it up and designing some policies. You can expect to learn the following: How to enable PBM How to create a policy The different…
-
Local TempDB on SQL 2012
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 longer new information, it has not been talked about all that much. I’m talking about the new feature in SQL Server 2012 that allows you to put TempDB on local…
-
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 SQL Server. A default instance of SQL Server uses port 1433. That’s just the default and you can change it to whatever you want. Bear in mind that if you…
-
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 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 everything is removed and we…
-
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 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 code indicates the cause of…
-
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 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 “NT Service” accounts are virtual…
-
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. 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 for multiple things and I…
-
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 that we step outside the DBA comfort zone since it requires the use of Active Directory and Group Policy Objects. There are many different ways that Active Directory can impact…
-
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 only had an hour so I had to scale the content back and because of that I had a ton of questions. I answered what we had time for on…
-
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 I thought I blogged about it and never did or it got lost when I had to change hosting providers late last year. My apologies for those who have been…