November 26, 2013 at 11:43 pm
Hi,
Will it affect domain changes in log shipping and mirroring???
Because currently SQL server services running on xxxx\xxxxx domain account and log shipping and mirroring working properly. We are planning to change our domain account to yyyy\xxxx so will it affect current log shipping and mirroring configuration for this changes.
Its very urgent kindly let me know.
Thanks.
Pradeep
November 27, 2013 at 9:28 am
Most likely yes, for log shipping you will have at least one folder where the transaction log backups persist. And the SQL Accounts used by the log shipped destination will need read and or write depending on which purpose the server is for.
That means at a share level the permissions will be set for the account(s) to access the share, if the account is changed to a new domain account and the new account(s) are not granted the relevant permissions on the share they will not be able to write \ read the backup files.
For mirroring it will depend on whether you are using a SQL Account or the Service account for connecting across the end points.
MCITP SQL 2005, MCSA SQL 2012
November 29, 2013 at 6:16 am
pradeep.mohan (11/26/2013)
Hi,Will it affect domain changes in log shipping and mirroring???
Because currently SQL server services running on xxxx\xxxxx domain account and log shipping and mirroring working properly. We are planning to change our domain account to yyyy\xxxx so will it affect current log shipping and mirroring configuration for this changes.
Its very urgent kindly let me know.
Thanks.
Log shipping may cross domains or workgroups easily, see my article at this link[/url] for more info.
For database mirroring you will need to use certificated users between computers in different domains or in workgroups.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply