Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Domain Migration - Log Shipping and Mirroring Expand / Collapse
Author
Message
Posted Tuesday, November 26, 2013 11:43 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 28, 2014 12:44 AM
Points: 91, Visits: 322
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
Post #1517913
Posted Wednesday, November 27, 2013 9:28 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, August 11, 2014 6:37 AM
Points: 299, Visits: 561
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
Post #1518128
Posted Friday, November 29, 2013 6:16 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:57 AM
Points: 6,304, Visits: 13,601
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 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"
Post #1518533
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse