Connection failure over VPN hosted SQL server

I'm trying to connect to a remote SQL Server database through a VPN client. I'm using the connection settings to test the connection in Visual Studio 2013 for Web. I've tried the same procedure over a computer on the same network at the place where I work and it connects successfully.

I can connect through the VPN to the server. I get back a successful ping to the server listening on port 4500. I've tried the server name and the IP address with the port number. I've tried leaving it default and with the SQL Server port default. I use SQL Server authentication with the correct username and password, and the db name is also correct. All this done while connected to the VPN.

I've tried the settings for both OLE DB and SQL Server.

Answers


The default SQL Server port is 1433 (although, as you mention, you've successfully connected while on the same network. I’ll assume you’re setup on 4500). I'd recommend checking firewall rule/port settings on the client machine you’re trying to connect from (as a quick test, you could temporarily switch your firewall off before fiddling with firewall rules). Also, if possible, check that the VPN allows connections over the port; it’s less likely than firewall, depends on what and how the VPN’s setup.


Need Your Help

How to use MVC 3 @Html.ActionLink inside c# code

c# asp.net-mvc asp.net-mvc-3 model-view-controller html.actionlink

I want to call the @Html.ActionLink method inside a c# function to return a string with a link on it.

How do I get cx_Oracle to work on 64-bit Itanium Windows?

python windows 64bit cx-oracle itanium

I'm running Windows Server 2003 on a 64-bit Itanium server which is also running 64-bit Oracle 10.2, and I'd like to install cx_Oracle for Python 2.5. I've used cx_Oracle before many times on both

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.