sql server services

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike - 30 May 2007 18:49 GMT

I took over a project and the former developer installed sql server 05 and
all of the sql server services are running as 'Local System' account. Should
they be running under the SA account if so how would I change the services
to run under the SA id and password?

Reply to this Message

Pete Berry - 30 May 2007 21:05 GMT

> I took over a project and the former developer installed sql server 05 and
> all of the sql server services are running as 'Local System' account. Should
> they be running under the SA account if so how would I change the services
> to run under the SA id and password?

Absolutely not -- way too much authority and will leave your server
totally vulnerable. The best way is to set them up under a domain
service account, and use a separate one for each service. 'Local
system' is less secure, and means that multiple instances, services, and
other services such as Exchange will not be able to communicate.

Signature

Graham (Pete) Berry
PeteBerry@Caltech.edu

Reply to this Message

Hari Prasad - 31 May 2007 03:11 GMT

Hello,

Take a look into the below URLs:-

http://www.sqlservercentral.com/columnists/bknight/10securingyoursqlserver.asp

http://technet.microsoft.com/en-us/library/ms345380.aspx

Thanks
Hari

>I took over a project and the former developer installed sql server 05 and
>all of the sql server services are running as 'Local System' account.
>Should they be running under the SA account if so how would I change the
>services to run under the SA id and password?

Reply to this Message

Mike - 31 May 2007 12:34 GMT

thanks,
I'll check out the URL's and thanks for the input

Reply to this Message