I have a high-degree of certainty that this _is_ a feature of SQL 2000 and SQL 2005. I believe it was of SQL 7 as well, however I no longer have documentation to look at for something that old! (I have to rotate manuals out every few years.)
It's late here - I'll try to look it up online in the morning. :-P Regards, Michael B. Smith MCSE/Exchange MVP http://TheEssentialExchange.com From: Ken Schaefer [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 09, 2008 10:55 PM To: NT System Admin Issues Subject: RE: SQL 7 service account change 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> ~
