Where there is VPN to remote server and then access to the database via local network interface, how can one establish a remote link between one's computer (with a programme such as Visual Studio 2010) and SQL Server (e.g. 2008 R2) ?

Any attempts to create a direct link to the SQL Server are blocked. Whilst the SQL Server can be configured to allow external access, this provides its own host of problems.

Any help would be much appreciated.

  • 1
    Do you mean the VPN is between the client machine and the SQL server directly?
    – cjk
    Commented Jul 26, 2012 at 15:55

1 Answer 1


If the VPN is between you and the SQL server, you may need to add users with permissions on the SQL server allowing remote access for them originating from your VPN servers IP.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.