All seems to have worked as expected. The new service account was granted the necessary rights to logon as service, etc. For what it's worth, I did use the EM from SQL 2000 client tools.
thanks again guys, Andrew. On Jan 9, 2008 11:01 PM, Michael B. Smith <[EMAIL PROTECTED]> wrote: > > 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> ~
