Networks

Ask something
Discussion Locked

Cnnecting 2 SQL servers with no TCP/IP

0 helpful
5 replies

by pererap01

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

need to get connected to aremote server without using a TCPIP
protocol.Actually we need to syncronize two servers and the service
providers(who host the remote sql Server)are not prepared to open the required
port (1433) therefore getting connected through Tcpip is out of question .
How we planned to get connected to the remote server is by adding a
server alias using TCPIP protocol.... and as the s.p didnt agree to open the
port ... we r in deep trouble....so i need to know if there is a way that we
could get connected to the remote server instead of using TCPIP.

5 replies

by stillatit

See if the service provider is willing to put in a vpn server for you to come through (with appropriate authentication and encryption). This would require opening a hole in the firewall for the vpn port, going to a specific box. It is still TCP/IP, but it is MUCH more secure than opening port 1433, which anyone can walk through with very little in the way of security.

Other than that, the old phrase "Never underestimate the bandwidth of a FedEx box full of tapes" comes to mind...

Good luck.

by mckaytech

I agree with the first answer as regards VPN being a plausible solution.

But I also wanted to offer the thought that if your "service" provider is unable to provide a level and type of service that will meet your business need, it is perhaps timeto evaluate other providers.

paul

This discussion is closed to new replies.