Change from Local System Account

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Change from Local System Account

Author

Topic

coolerbob
Aged Yak Warrior

841 Posts

Posted - 2007-04-30 : 09:05:18

Just spotted that some cowboys install a Live DB Server using Local System Account for the SQL Server Service.
Gonna change it to a Domain Admin Account tonight.
Anyone got any advice or warnings about any "gotchas" I might run in to during a job like this?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-04-30 : 13:00:23

Ensure that domain account is valid sql login.

coolerbob
Aged Yak Warrior

841 Posts

Posted - 2007-05-08 : 11:18:18

Interestingly, after doing this, I tried to run SS SP2 and it still failed.
This was the reason: http://support.microsoft.com/kb/916766

for those of you who are interested, this is also worth checking:
Does sql service account has following user rights on the server?

Act as part of the operating system
Increase quotas
Log on as a batch job
Log on as a service
Replace a process level token
Bypass traverse checking (that is usually set for Everyone anyway)
Lock pages in memory
access this computer from the network
backup files
restore files
increase scheduling priority
load & unload device drivers

as outlined here:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81791

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-08 : 15:41:18

Setup assigns those user rights during installation. In sql2k, those user rights are assigned if you change service account in em. But in sql2k5, ...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources