+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, SQL 2008 AD groups in Technical; Hi, I've recently merged our admin and curriculum network together. The old admin FR server was also the SIMS server ...
  1. #1
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    561
    Thank Post
    59
    Thanked 16 Times in 15 Posts
    Rep Power
    18

    SQL 2008 AD groups

    Hi,

    I've recently merged our admin and curriculum network together. The old admin FR server was also the SIMS server and so when I migrated to SQL Server 2008 to host SIMS a while back, it created a number of groups within AD. However the SIMS server has now been demoted to a member server and joined to our curriculum network so these groups no longer exist within AD.

    I have since found out that the 2008 SQL install adds the following groups with stated members:

    SQLServerMSSQLServerADHelperUser$SERVER_NAME
    NT AUTHORITY\NETWORK SERVICE
    NT AUTHORITY\SYSTEM

    SQLServerMSSQLUser$server_name$SIMS2008
    NT AUTHORITY\SYSTEM

    SQLServerSQLAgentUser$SERVER_NAME$SIMS2008
    NT AUTHORITY\NETWORK SERVICE

    SQLServer2005SQLBrowserUser$SERVER_NAME

    I have Two questions

    1. Should all these groups be present within AD or "Local Users and Groups->Groups"?

    2. What users/groups should be a member of each of these?

    TIA

  2. #2

    Join Date
    Jan 2006
    Location
    Surburbia
    Posts
    2,178
    Thank Post
    74
    Thanked 307 Times in 243 Posts
    Rep Power
    114
    AIUI: Unless you are clustering on member servers/workstations all the SQL groups are local groups. You only get domain groups on a DC because the SQL install has no other options i.e. it can't make & use local groups on a domain controller.

    I've only got an Express to hand used for something else, but that is the same local groups & members as you listed plus:

    SQLServer2005SQLBrowserUser$SERVER_NAME
    NT AUTHORITY\LOCAL SERVICE

    SQLServerFDHostUser$SERVER_NAME$INSTANCE_NAME
    <no members>

    SQLServerReportServerUser$SERVER_NAME$MSRS10.INSTA NCE_NAME
    NT AUTHORITY\SYSTEM
    <but I *explicitly* installed the report service >

  3. Thanks to PiqueABoo from:

    randle (24th August 2010)

  4. #3
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    561
    Thank Post
    59
    Thanked 16 Times in 15 Posts
    Rep Power
    18
    Many thanks for that. I've added them to the Local users & groups section of the server along with your additions (I also have reporting installed) and will just have to wait and see what happens during the next upgrade

SHARE:
+ Post New Thread

Similar Threads

  1. Moodle / Server 2008 / IIS7 / MS SQL Server 2008 Express
    By Kamran7860 in forum Virtual Learning Platforms
    Replies: 3
    Last Post: 23rd November 2010, 06:03 AM
  2. SQL 2008 Licensing
    By Richie1972 in forum MIS Systems
    Replies: 33
    Last Post: 17th July 2010, 12:35 AM
  3. New SIMS Server - Windows 2008 R2 & SQL 2008 R2
    By MYK-IT in forum MIS Systems
    Replies: 23
    Last Post: 17th June 2010, 09:31 AM
  4. sql 2008
    By THERADIOTUBBY in forum MIS Systems
    Replies: 5
    Last Post: 1st June 2010, 09:09 AM
  5. Windows 2008, SQL 2008 and Backup Exec 12
    By joe90bass in forum Windows
    Replies: 2
    Last Post: 5th May 2010, 02:49 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •