Cross Domain Logshipping - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Cross Domain Logshipping

Author

Topic

sameerDB
Starting Member

4 Posts

Posted - 2011-08-03 : 07:29:50

Hi,

I want to configure the transaction log-shipping but the environment i have is
1] Primary server which is part of Cluster Instance in one domain
and different physical location.
2] My Secondary server will be on different domain and physical location
3] My MSSQL services running on the Primary server are with the domain user and which I cannot change.
4] on secondary server I can change any thing.

Please help me.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-08-03 : 12:36:14

Is there a trust relationship setup between the two domains?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

sameerDB
Starting Member

4 Posts

Posted - 2011-08-04 : 00:41:16

No it is not there, Please tell me how do I Do that for log-shipping point of view?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-08-04 : 12:41:48

I believe that means you'll need to use local accounts with the same name and password and not domain accounts. Try setting it up this way and see if the LS share will work.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

sameerDB
Starting Member

4 Posts

Posted - 2011-08-05 : 02:54:13

Thanks Tara for reply.

But i can't do any changes on Primary server. The Primary server is one of the Instance running on Cluster server. it's not possible to change
service a/c on this server.

can I create the local user with same name & Password on secondary server as of primary server (which is a Domain user). will it work?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-08-05 : 13:59:57

I don't think that will work.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

sameerDB
Starting Member

4 Posts

Posted - 2011-08-09 : 23:55:24

I have done Some RND & found out the solution, as follows
Considering my environment
1] I have created the one local user on remote server (secondary server) & started mssql services (MSSQL Agent) with that user on secondary server.
2] Created the same user with same password locally with appropriate permissions (Created Pass through Authentication) on both the nodes on the cluster where on my primary Instance is running,.
3] Open the required ports for file share & MSSQL between the servers
4] Configured the Log-shipping

Thanks for you response.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-08-10 : 00:23:19

Great, glad you got it working.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

cchintham
Starting Member

1 Post

Posted - 2013-05-06 : 13:15:54

Hey Sameer,

Could you please Explain or mail me the process you followed to setup logshipping on different domian without changing account on primary.
You explained briefly, Deep dive on this topic will helps me alot because i am facing same issue.

Thanks
Chaithanya

chaithanya

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources