Service Account User for SQL Server

ta5
ta5 Member Posts: 1,164
edited 2011-05-30 in SQL General
Hello experts
As we all know sql server service can run under a domain user or a built in user (local system, etc.). I'm interested in your opinion about what do you think about this issue. Do you ever use "Local System"?
Thanks in advance.
Thomas

Answers

  • stryk
    stryk Member Posts: 645
    Hi!

    You should always use a dedicated domain account for the SQL Server services. This enables you to specify the security rights, e.g. if the SQL Server shoould access remote drives or servers (Log Shipping etc.)..
    This SQL Service account shoud be (IMHO) assigned to these groups:
    - Local Administrators
    - Lock Pages in Memory (must have with 32bit systems using AWE)
    - Perform Volume Maintenance Tasks

    Cheers,
    Jörg
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool

Categories