Solved

Windows Firewall blocking SQL over VPN.

Posted on 2013-10-28
5
662 Views
Last Modified: 2013-11-03
I'm trying to get an SQL program to connect from a Windows 7 client machine connected to an SBS 2008 box via VPN. The remote machine is not connected to the domain itself. I've made the VPN a work network, and opened created Windows Firewall rules to allow the relevant ports through (the software has a custom TCP port and the standard SQL UDP port).

I know it's Windows Firewall related, because the moment I turn it off the program works, it just won't connect when it's on, even with the ports opened.

Anyone got any ideas?

Cheers! Sam
0
Comment
Question by:icemedia
  • 3
5 Comments
 
LVL 16

Expert Comment

by:Brian Pringle
Comment Utility
Do you know what all ports is uses?
0
 
LVL 10

Expert Comment

by:PadawanDBA
Comment Utility
What ports did you allow in windows firewall?  Also, is this a default instance or a named instance of SQL server?
0
 

Author Comment

by:icemedia
Comment Utility
It's SQL2005, named instance. The instance uses SQL authentication, and TCP port 14330 and UDP port 1434. I've opened those up in Windows Firewall, but it still won't connect.
0
 

Accepted Solution

by:
icemedia earned 0 total points
Comment Utility
Fixed it myself. I'd set my firewall rules to allow the configured ports, but hadn't taken into account that SQL actually uses another dynamically assigned port which was being blocked. I amended my firewall rules to include all ports and locked the rules down to the specific program, and that's working fine now, Cheers everyone who posted.
0
 

Author Closing Comment

by:icemedia
Comment Utility
I fixed this issue myself after some further testing.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

A quick step-by-step overview of installing and configuring Carbonite Server Backup.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this Micro Tutorial viewers will learn how to use Boot Corrector from Paragon Rescue Kit Free to identify and fix the boot problems of Windows 7/8/2012R2 etc. As an example is used Windows 2012R2 which lost its active partition flag (often happen…
This Micro Tutorial will go in depth within Systems and Security in Windows 7 and will go into detail regarding Action Center, Windows Firewall, System, etc. This will be demonstrated using Windows 7 operating system.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now