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 domainand different physical location.2] My Secondary server will be on different domain and physical location3] 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 |
|
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 |
|
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 |
|
sameerDB
Starting Member
4 Posts |
Posted - 2011-08-09 : 23:55:24
|
I have done Some RND & found out the solution, as followsConsidering my environment1] 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 servers4] Configured the Log-shippingThanks for you response. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
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.ThanksChaithanyachaithanya |
|
|
|