April 29, 2004 at 11:23 pm
The domain account used on all 6 of our SQL servers is being retired and we must switch to a new AD account withing 30 days. I have been warned elswhere that the steps to change the IDs must be done in a particular order if you have replicated tables between servers. What are the issues surrounding this? And will I be able to do this without breaking replication?
Thanks,
G
April 30, 2004 at 5:06 am
If 'retired' means deleted and you have to set up a fresh account for the servers (ie new SID and all), I believe that your safest bet would be to;
drop the replication (meaning finsish it up cleanly)
stop SQL Services
change to the new account
start SQL Services
re-apply replication again
...being in no way any replication guru, my gut tells me that deleting the security identity for the servers + replication an expect all to transfer flawlessly to a new security context (that is what accounts are) is perhaps a wee bit too much to hope for.
Better to shut it down in a controlled fashion, make the changes and bring it up again.
/Kenneth
April 30, 2004 at 9:38 am
1. Make sure the new service account is part of the windows user group
2. give the new service account to read/execute not full control on your c:\
3. give the new service account full control on it's program file folder.
4. give the new service account full control on every drive that sql server use for data, log and backup.
5. add the new service account to logins and give it sysadmin server roles.
6. change sql agent service account to the new service account. (stop and start sql server agent)
7. change sql server service account to the new service account. (stop and start sql server.)
if you have sql-mail.
login to local server at the terminal using the new service account. (this new service account can't be logon using terminal service because it does not have administrators right.)
setup outlook.
8. setup sql-mail to link to the new outlook profile for sql server and sql-agent.
mom
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply