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
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.