Re: Local System account.



Hello Rogers,


You do not have to install SQL Server only using a domain account. However, in a Domain environment, you should use a domain account for SQL Server. Using a domain account lets SQL Server services communicate with other SQL Server installations, access network resources and interact with other Windows applications.

For a local setup, Local System account is not recommended nor for SQL Server neither SQL Server Agent.

Actually, Local System account has administrative priviliges and has full rights on the (only) local computer.


--
Ekrem Önsoy



"Rogers" <naissani@xxxxxxxxxxx> wrote in message news:OexQPM%236HHA.2632@xxxxxxxxxxxxxxxxxxxxxxx
Is it mandatory to install SQL Server under domain user, I can't install under local system account? When I tried to install under local system it gave me access error but I installed under a user which has administrative privileged it installed perfectly, now the question is if I want to install under local system how can I give full permission to local system account as I installed SQL Server via administrative account and I don't have a domain.

Plz advice.




.



Relevant Pages

  • Re: sa password was inadvertently changed. With a kicker...
    ... Use some other account that the client has (any domain admin should have ... Did around there install package, and see if the sql script that changed ... Put the database files back where they should ... > I have a SQL Server 7 Standard edition server running in a ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Sever 2008 RC0 fail to install almost all services
    ... Now I removed the account from local Administrators group. ... The SQL Server Log File reports an error 15209, ... Note that I use a specific account named SQLServerServices to install ... This is an informational message only. ...
    (microsoft.public.sqlserver.setup)
  • Re: Compromise?
    ... >made the patches available and advised customers to ... >install it. ... >>Server was installed and if your SQL Server is running ... >>administrator account, you just gave anybody who has a ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server 2008 set up
    ... work on this Account so I would like to use that. ... "SQL Server System Administrators" list during SQL Server 2008 Setup. ... The install completed successfully. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.setup)
  • Re: Problems changing the password for the service account in SQL
    ... Adding the domain account which runs SQL Server into SQL Server doesn't ... Server if it is running under the domain account. ... Admin-SQL, Logon Exec - exception from ...
    (microsoft.public.sqlserver.security)