September 28, 2006 at 8:48 pm
Hi
Most of my other mssqlserver service, logon using the localsystem account.
One of mine mssqlserver service was belong to the /adminuser instead of localsystem. This because, once the /adminuser password changed, my operation guys will having problem to start the mssqlserver services after server rebooted. Definatly, having a /adminuser pass is not possible.
Q: If i change the logon to localsystem, is there any impact or implication to the database?
Thank you
Dunstan
October 2, 2006 at 8:00 am
This was removed by the editor as SPAM
October 2, 2006 at 8:31 am
You can change the services back to localsystem logon, this should not affect any of the other services.
------------
Prakash Sawant
http://psawant.blogspot.com
October 2, 2006 at 8:39 am
You can make the change and it will require your sqlserveragent service to be restarted, because you'll have to restart the mssqlserver service in order for the change to take place.
Generally speaking, though, running as the local System account is not advised. It is preferable to run as a domain or local computer user instead. Especially one without administrative rights on the server (though you should understand the ramifications of this before doing so).
K. Brian Kelley
@kbriankelley
October 2, 2006 at 2:22 pm
If you have jobs that access files in other servers, the job will fail when using LocalSystem.
October 3, 2006 at 12:45 am
Hi guys, thanks for the reply and advice.
Regard
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply