MS SQL Server Public

ITsolutionWizard
ITsolutionWizard used Ask the Experts™
on
I have VPS MS SQL Server 2008 hosting on GoDaddy.com and I want to open access to a website that is on another VPS and that is hosting on GoDaddy.com as well. What is the best way and how can I do it?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Distinguished Expert 2017

Commented:
BEST OPTION is using a VPN ipsec between the two.
opening it up to the public is not advisable.
If the VPS are on the same network(IP segment).........

Author

Commented:
They are not same
Distinguished Expert 2017
Commented:
What if any control do you have it might be open by default if they provide firewall, you would need to use port forwarding to allow access to the port on which you configured ms sql tcp/ip to listen on.

opening an SQL server to the outside is not advisable, since your VPS is from the same vendor see whether they have and option or can manage the access from one VPS to the other without opening SQL to everyone on the net.
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
Did you enquire GoDaddy support about this?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial