Re: Which Account to run SQL Service under? Best Practice?

From: danA (dea_at_deamon.com)
Date: 04/06/05 

Date: Wed, 6 Apr 2005 11:43:01 +0100

I am using SQL Server 2000 on Windows 2003+SP1.
I have a problem with running the SQL services under a regular USER account.
I created a local user account, member of the USER group and setup the SQL
service to run under that account.
The service couldn't be started (Access denied) until I made that user also
member of Administrators.
What could be wrong?
Thanks,
Dan

"Jason Mauss" <jason.mauss@nospamgmail.com> wrote in message
news:%23lE0b1INFHA.1308@TK2MSFTNGP15.phx.gbl...
> found my answer here:
> http://www.microsoft.com/sql/techinfo/administration/2000/security/securingsqlserver.asp
>
> :)
>
> "Jason Mauss" <jason.mauss@nospamgmail.com> wrote in message
> news:epCx9vINFHA.2136@TK2MSFTNGP14.phx.gbl...
>> I'm going to be performing some SQL Server 2000 installations and I know
>> that during the setup process you are asked to specify which account the
> SQL
>> Server service should run under. Is it best (or not) to run under the
> Local
>> System account or an actual domain user?
>>
>> I'm thinking it's best to use the Local System since the domain user
>> could
>> (for some reason) be removed or have their password changed, etc.
>>
>> Opinions/Thoughts?
>>
>> Thanks,
>> Jason
>>
>>
>
>
>

Relevant Pages

  • Re: SQL account rights
    ... Please advice what is the best, suitable rights rather than domain admin ... Warren Brunk - MCITP - SQL 2005, ... Add it as a login to the SQL Server ... files, or backups, make sure that the service account has Full ...
    (microsoft.public.sqlserver.security)
  • Re: User authentication
    ... There are 2 SQL Server 2005 ... 1 SQL Server 2000 installed on another server ... Windows account instead to run backup jobs. ...
    (microsoft.public.sqlserver.clients)
  • Re: SQL 2000 Server gets hacked
    ... Thank you Beth. ... > placed a strong password on the 'sa' account?) ... Your SQl Service itself shouldn't be running as a ... (SQL Agent requires more, but not SQL Server). ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2000 Server gets hacked
    ... Thank you Beth. ... > placed a strong password on the 'sa' account?) ... Your SQl Service itself shouldn't be running as a ... (SQL Agent requires more, but not SQL Server). ...
    (microsoft.public.sqlserver.security)
  • Re: Microsoft Search service cannot be administered under the present user error SP3
    ... - Have not modified Administrator account, but i ran the SQL script anyway. ... SQL account is not a local administrator. ... > has this server ever been upgrade from SQL Server 7.0 or is this SQL ...
    (microsoft.public.sqlserver.fulltext)
Quantcast