Post reply

Confused with the Serive account and domail account

  • March 23, 2009 at 10:28 pm

    #130034

    Hi,

    Iam planning to install new sql server 2005 instance. For this

    1.Iam logging into the Server as abc\admin->administrator account

    2.adc\admin is a memeber of Administrator group in Mycomputer->management->groups.

    3.While installing sql server instance, in the service account page

    User name: abcservice

    Password:xxxxxxxxx

    Domain: ABC

    Installtion is done.

    Here my questions are

    1.Do we need to use abc\admin account in service account page?

    2.I used abcservice, in that case is this account has to be added as member of Administrator group?

    Please clarify me?

    thanks

  • March 23, 2009 at 11:30 pm

    #964968

    You don't need to use your administrator account for service account. In SQL Server 2005; when you set the service account for SQL Server Service it does not become a local administrator. It gets added to a local group that has limited permissions to your computer to let SQL Server operate normally.

    Thanks.

    Mohit.

    [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 2 posts - 1 through 1 (of 1 total)

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