Local System account.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rogers - 31 Aug 2007 16:24 GMT

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.

Reply to this Message

Ekrem Önsoy - 31 Aug 2007 16:54 GMT

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.

Signature

Ekrem Önsoy

> 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
[quoted text clipped - 5 lines]
>
> Plz advice.

Reply to this Message