Post reply

SQL Server Groups

  • June 9, 2011 at 9:33 am

    #252475

    Hi Folks

    a little confused (again) on SQL Server groups like these (i did not list them all)

    SQLServerMSSQLUser$ComputerName$MSSQLSERVER

    SQLServerSQLAgentUser$ComputerName$MSSQLSERVER

    SQLServerMSASUser$ComputerName$MSSQLSERVER

    I just installed SQL Server 2008 R2 and everything is running

    The question is do I need to add the Domain Service Log on for all the SQL services to each of these groups?

    I remember doing it in SQL Server 2005 for some reason

    Thanks

    Jim

  • June 9, 2011 at 10:05 am

    #1336461

    No. That action should have been performed as a part of the install and is why you see those groups like that.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • June 9, 2011 at 10:14 am

    #1336468

    My followup question is there are no members in any of these groups, so should there be ?

    Thanks

    Jim

  • June 9, 2011 at 10:18 am

    #1336472

    No. It doesn't prevent the addition of an account to it, but it should be good to go already.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply