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

From: Jason Mauss (jason.mauss_at_nospamgmail.com)
Date: 03/29/05 

Date: Tue, 29 Mar 2005 10:30:15 -0800

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

  • Which Account to run SQL Service under? Best Practice?
    ... 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 ... System account or an actual domain user? ... I'm thinking it's best to use the Local System since the domain user could ...
    (microsoft.public.sqlserver.security)
  • Re: Replication problems
    ... The error that you are getting regarding using a system account is fine as ... machine share which you can then reference in the publication wizard. ... > SQL Server Enterprise Manager could not retrieve information about the ...
    (microsoft.public.sqlserver.ce)
  • Re: Newbie question on SQL connection
    ... > Let me educate you about SQL Server security. ... granting permissions to these accounts in SQL ... > maintain its own user accounts, which are separate from domain user ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Windows authentication on SQL server
    ... AFAIK, you *cannot* have anything that executes as ... LocalSystem do any type of Windows authentication against another machine. ... the service account to a domain account, or make you extended procedure do a SQL server logins... ... >> AFAIK, system account doesn't exist outside the machine, so you cannot add system account from ...
    (microsoft.public.vc.language)
  • Re: Windows authentication on SQL server
    ... AFAIK, you *cannot* have anything that executes as ... LocalSystem do any type of Windows authentication against another machine. ... the service account to a domain account, or make you extended procedure do a SQL server logins... ... >> AFAIK, system account doesn't exist outside the machine, so you cannot add system account from ...
    (microsoft.public.sqlserver.programming)