In article <OVS7qLuoHHA.716@xxxxxxxxxxxxxxxxxxxx>, me@xxxxxx says...
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.
--
Graham (Pete) Berry
PeteBerry@xxxxxxxxxxx
.
Re: Local System Account & Network Access ... helpful and Roger's suggestion to use local service instead of local system...account on a domain computer. ...membership but they do have a bearing on what a user/computer has access ...Logon ID: ... (microsoft.public.security)
Re: Local System Account & Network Access ... In that white paper I posted the link for you see this about local system...account on a domain computer. ...membership but they do have a bearing on what a user/computer has access to ...Logon ID: ... (microsoft.public.security)
Re: Local System Account ... run following command from command line: ...Local System will also run as Local System. ... one can specify it to run as localsystem account....administrator is not same as Local System. ... (microsoft.public.win2000.security)
Re: win service and HKCU and SHGetFolderPath with CSIDL_APPDATA ... >> Actually I have a LSP dll that is loaded by ... I have tried the service with Local System, Local Service, Network Service ... In all of these cases I was able to access HKCU for read and write as well. ... > local account can access the file), define a normal account as the service ... (microsoft.public.dotnet.languages.vc)
