question

nikhil_satam avatar image
nikhil_satam asked

Can SQL Server Database Replication be implemented without having both the Servers on same network domain? How to implement communication between 2 servers in this scenario?

Suppose if I have 2 SQL Servers: 1. SQL Server 2014 Web Edition Database on Cloud (not Azure) 2. SQL Server 2014 Standard Edition with same Application database on Local Premises Now, if I need to replicate (PUSH) data from Local Premises DB Server Database named as LabProdData to Cloud DB Server Database LabProdData, what are the options to implement this scenario? Can SQL Server Replication support this with 2 DB Servers of same version but one is Web Edition and other is Standard. We need to push data from Standard Edition to Web Edition. How can the communication be implemented between both these servers? Note: Network Domain or Active Directory do not exists. Please advise. Thanks.
replicationsql server 2014mirroring
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

perrywhittle avatar image
perrywhittle answered
standard edition may act as a publisher and\or subscriber, so no problem there. Web edition may only act as a subscriber, as long as that's all you need it to do that will be fine too. The security mechanism in replication uses sql server authentication, this promotes replication between machines on disparate domains\networks Regards Perry
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks Perry. I did tried configuring Transactional replication between my Local DB Server (SQL Server 2014 Standard) and Data Center DB Server (SQL Server 2014 Web Edition). My Local DB Server is able to connect to the Data Center/Cloud DB Server through SQL Server Management Studio. But my Cloud DB Server is not able to connect to the Local DB Server (which has a public IP natted on Firewall). The Public IP of the Local DB Server can be pinged successfully from my Cloud DB Server. Can you please help me with how should I configure the Publication from my Local DB Server to allow the Cloud DB Server to subscribe the publication/data. Cloud DB Server must be the Subscriber/Target/Receiver and Local DB Server must be the Publisher/Source. Thanks in advance for your help!!
0 Likes 0 ·
nikhil_satam avatar image
nikhil_satam answered
Thanks Perry. I did tried configuring Transactional replication between my Local DB Server (SQL Server 2014 Standard) and Data Center DB Server (SQL Server 2014 Web Edition). My Local DB Server is able to connect to the Data Center/Cloud DB Server through SQL Server Management Studio. But my Cloud DB Server is not able to connect to the Local DB Server (which has a public IP natted on Firewall). The Public IP of the Local DB Server can be pinged successfully from my Cloud DB Server. Can you please help me with how should I configure the Publication from my Local DB Server to allow the Cloud DB Server to subscribe the publication/data. Cloud DB Server must be the Subscriber/Target/Receiver and Local DB Server must be the Publisher/Source. Thanks in advance for your help!!
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

This is something you'll need to work on with your firewall admins. It may be they won't allow the traffic in the first place
1 Like 1 ·
sjimmo avatar image
sjimmo answered
How is your package setup? What is the login that is being used? Does this login have access to the subscriber domain/server? You should probably setup a pass-through account on both ends and have your replication package/subscription use this account. This is a very good KB about doing what you are trying to do: https://support.microsoft.com/en-us/kb/321822
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks sjimmo I am not using a ETL package. I am trying to configure Transactional Replication by using the Publisher as my Local/on-premises SQL Server and Subscriber as my cloud/data-center SQL Server. Thanks for the article link. I will go through it and give it a try once. Meanwhile, my network team is trying to configure a VPN tunnel setup between my data center SQL Server and Local On-Premises SQL Server. Do you think that will solve my problem? I appreciate your assistance!! Thank You!!
0 Likes 0 ·
sjimmo avatar image
sjimmo answered
The package I was talking about is the replication package at the publisher. You need to ensure that the logins are able to talk to each other across the domains, which will be a task for your networking folks. Have them read this: https://support.microsoft.com/en-us/kb/321822
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

jagan avatar image
jagan answered
Hi nikhil, I am looking for tran replication for SQL server 2012 standard(non domain) to Sql server 2012 web ( Non domain). Please help me with this. Please give me a description for that how u achieved without domains.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.