Post reply

SQl 2008 Installation Accounts = confusion!

  • December 8, 2008 at 5:20 pm

    #198551

    During the install of sql 2008 we arrive at the page we the service accounts are entered.

    For Sql Server I find:

    nt authority\ networking services (note the space between "networking" and "services")

    nt authority\ system services

    For SS Analysis Services I find the same as above plus:

    nt authority\ system

    FOR SS SSIS I find

    nt authority\ networkingservices (withtout the space; similiar to the Sql Server account)

    Can anyone clarify (URL is fine) the distinction between these accounts and which is preferred?

    TIA,

    barkingdog

  • December 9, 2008 at 6:37 am

    #909589

    Personally, and this is just a personal opinion, I would ditch the lot and go with domain logins (with carefully assigned rights) or defined local logins.


    Shamless self promotion - read my blog http://sirsql.net

  • December 9, 2008 at 7:52 am

    #909656

    Not sure what those are. Typically there are LocalSystem, LocalService, and NetworkService as the accounts.

    I agree with Nicholas, I'd set up domain accounts, no rights, and let SQL use them to run services. It's a few seconds and doesn't hurt.

    The recommendation is LocalService unless the account needs to access something on the network, when NetworkService is required. If you need to actually authenticate with files on another server, like SSIS, you need a domain account.

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

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