Post reply

What is <Domain>\SQLSERVICE Account?

  • August 11, 2011 at 3:32 am

    #246133

    What is <Domain>\SQLSERVICE Account?

    From where this account has come?

    Thanks

  • August 11, 2011 at 4:17 am

    #1367144

    In most companies the sql server service ( under services.msc) is run under a service account such as the one you mentioned above.

    The aim here is to have sql server start up using a account with minimal permissions.

    Some good links on this topic

    http://technet.microsoft.com/hi-in/library/cc170953%28en-us%29.aspx

    http://msdn.microsoft.com/en-us/library/ms143504.aspx

    The account usually needs only log on as service , registry access and file system access to the folder where the db files are loacted.

    Jayanth Kurup[/url]

  • August 11, 2011 at 4:56 am

    #1367160

    Sounds like an account that was manually created in your Active Directory domain for the express purpose of running SQL Server and/or SQL Agent Service accounts. But you should ask your domain admin or your SQL Server installer this question. \SQLService is NOT an account that is created automatically by SQL Server and just because the account is called SQLService doesn't mean that's what it's actually being used for.

    People don't always name things for what they're actually using them for, and sometimes they "expand" the original purpose by adding addition crap to the object.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

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