February 10, 2012 at 11:10 am
We recently acquired a group of SQL Servers form another team and would like to change the SQL Server service account. These servers are setup with database mirroring and are configured with a different service account.
What would the impact of changing the service account be on database mirroring ? Do we have to break the mirror and set it up again ?
Note:The new service account would be a domain account.
February 10, 2012 at 5:40 pm
pause mirroring and change the service account(s).
Ensure you change the mirroring endpoint(s) security and resume mirroring.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 10, 2012 at 8:13 pm
Thanks. I will give this a shot.
February 22, 2012 at 8:34 am
It worked. Thanks for the advice.
February 22, 2012 at 8:41 am
SQLback (2/22/2012)
It worked. Thanks for the advice.
You're welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply