Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I was tracking down some permissions issues on SSRS 2012 and I started looking for the local groups that I am used to seeing for SQL Server. I noticed something I had not seen before, the groups have changed in 2012.

Windows Groups Screenshot

I have checked on some of my other 2012 instances and am seeing similar. Is everyone seeing this?

I have checked BOL but am a finding it a little unclear. I found this information from Bob Beauchemin. It looks like he is seeing the same thing I did.

My question is, does everyone else running 2012 see the same thing?

share|improve this question
up vote 3 down vote accepted

Jon, From what I've seen, the local Windows groups are going away in favor of using the NT SERVICE SIDs on W2K8R2 -

HTH, Nancy Hidy Wilson

share|improve this answer
That is what I was seeing too but I guess I just didn't find the BOL clear. Maybe I am just tired. :-D. Thank you for the quick reply. – jgardner04 May 2 '12 at 3:29

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.