SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Cross Domain Logshipping
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sameerDB
Starting Member

India
4 Posts

Posted - 08/03/2011 :  07:29:50  Show Profile  Reply with Quote
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

USA
36845 Posts

Posted - 08/03/2011 :  12:36:14  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page

sameerDB
Starting Member

India
4 Posts

Posted - 08/04/2011 :  00:41:16  Show Profile  Reply with Quote
No it is not there, Please tell me how do I Do that for log-shipping point of view?

Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36845 Posts

Posted - 08/04/2011 :  12:41:48  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page

sameerDB
Starting Member

India
4 Posts

Posted - 08/05/2011 :  02:54:13  Show Profile  Reply with Quote
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?
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36845 Posts

Posted - 08/05/2011 :  13:59:57  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page

sameerDB
Starting Member

India
4 Posts

Posted - 08/09/2011 :  23:55:24  Show Profile  Reply with Quote
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.

Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36845 Posts

Posted - 08/10/2011 :  00:23:19  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page

cchintham
Starting Member

USA
1 Posts

Posted - 05/06/2013 :  13:15:54  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000