SQLServerPedia Syndication
All posts in this category get syndicated to SQLServerPedia.com
-
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…
-
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 all good stuff! We just moved, and moving a family is not fun. It was a long process from selling the old house to searching and finding a new one.…
-
Holy Schnikes I’m Speaking at PASS Summit 2013
I am beyond excited to announce that I have been accepted to speak at the annual SQL PASS Summit 2013 in Charlotte, NC. This will be my first time to speak at this event and I can’t wait! The session I will be presenting is titled “How Active Directory Affects SQL Server”. I have been…
-
Policy Based Management On Change: Prevent not available
Policy Based Management has 4 evaluation modes and if you are not already familiar with them you can go HERE to get more information. Today I want to talk about the “On Change: Prevent” mode and why you don’t always see it as an option. The options you see available are dependent on the facets…
-
Renaming Server with SQL
I recently had to rename my laptop on which I have two SQL server instances. I have a default instance and a named instance. I actually have had the laptop renamed for awhile without any issues, but it’s not production and I don’t use it every day. I first encountered the error while creating a…
-
User Group Marketing
I blogged about this back in September of 2010, but technology changes so it’s time to revisit this again. Now I’m not anything even close to a marketing expert, but I’ve been the Director of Logistics and Communications for the North Texas SQL Server User Group for the past 2 years (I just started a…