Service Account Question

  • Hi,

    Iam using the abcservice as servic eaccount which domain account. My question is this Domain account should be added to the Local Administrator group of the box or NOT?

    Please see the attachement to better understand.

    thanks

  • Please look at this link : http://msdn.microsoft.com/en-us/library/ms143504.aspx

  • No!

    In SQL Server 2005 the account does not need to be part of Local Admin group. If you configure the SQL Server services using SQL Server Configuration manager it will get proper permission assigned to it.

    In SQL 2005 you never do any assignment using just regular Service console; always use the "SQL Server Configuration Manager" becuase it will do permissions for the account you choose on what SQL Server will need to operate.

    Thanks.

    [font="Arial"]---

    Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
    Microsoft FTE - SQL Server PFE

    * Some time its the search that counts, not the finding...
    * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

    How to ask for help .. Read Best Practices here[/url].

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

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