My recollection was that this didn't happen. SQL Server setup validates that the custom account you want to use has the necessary permissions (or it gives you an error message and doesn't install). It doesn't give the account the necessary extra properties. I'm pretty sure that changing it via EM is the same (i.e. to doesn't automagically give the account more properties). Additionally, if you had SPNs registered under the first account (SQL Server setup does this for you), you need to manually reregister them when you change accounts.
Cheers Ken From: Michael B. Smith [mailto:[EMAIL PROTECTED] Sent: Thursday, 10 January 2008 11:14 AM To: NT System Admin Issues Subject: RE: SQL 7 service account change SQL 7. Wow. That's like --- so last century. As I remember, yes it will. Regards, Michael B. Smith MCSE/Exchange MVP http://TheEssentialExchange.com From: Andrew Laya [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 09, 2008 6:20 PM To: NT System Admin Issues Subject: SQL 7 service account change Looking for confirmation. I need to change the service account on a MS SQL 7.0 server. If I simply change the account and password on the Security tab for this server within Enterprise Manager, will it take care of all the rights / permissions etc needed to run the service? thanks, Andrew. ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~
