SQL Server remote connection between two servers
-
Hi Everyone, I would like some help on a project please. If I have 2 servers in different countries, both have SQL server express 2014 installed. I would like to view a remote server connection between the two servers. Will the connection be possible if I allow remote connections on both servers, or do I have to use a VPN between the two servers? Thanks a lot for your help. Marie
-
Hi Everyone, I would like some help on a project please. If I have 2 servers in different countries, both have SQL server express 2014 installed. I would like to view a remote server connection between the two servers. Will the connection be possible if I allow remote connections on both servers, or do I have to use a VPN between the two servers? Thanks a lot for your help. Marie
Member 12789265 wrote:
Will the connection be possible if I allow remote connections on both servers, or do I have to use a VPN between the two servers?
A VPN would be recommended. SQL Server is usually only approachable from the local network. If it is approachable over the internet, you are taking a rather big risk.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)