Take the 2-minute tour ×
Webmasters Stack Exchange is a question and answer site for pro webmasters. It's 100% free, no registration required.

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.

share|improve this question
1  
Do you mean the VPN is between the client machine and the SQL server directly? –  cjk Jul 26 '12 at 15:55
add comment

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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