SQL Server Performance

service account permissions

Discussion in 'SQL Server 2005 General DBA Questions' started by Trev256b, Jul 10, 2011.

  1. Trev256b Member

    if i add the sql server serice account as a local adminsitrator on the sql server, do i need to specify any other permissions. i don't think so but i saw 2 documents that said the follwoing permissions need to be set and these are both different and do not match wha the microsoft site states as minimal permissions.
    Should i ignore the following 2 suggestions if the sql server service account has local administrator rights on the sql server?
    suggestion 1: add the following rights to the sql server service account:
    -act as part of the operating system
    -allow log on locally
    -logon as batch job
    -full control on all data drives
    -stop, start, pause service
    suggestion 2: add the following rights to the sql server service account:
    -act as part of the operating system
    -allow log on locally
    -logon as batch job
    -logon as a service
    -replace as a process level mtoken
  2. satya Moderator

    If the login is a local admin in addition to the rights you have specified... its enough there aren't any other settings you need.
    If you can be more specific about thsoe 2 documents it will help to see what you mean.

Share This Page