Solved

Windows Firewall blocking SQL over VPN.

Posted on 2013-10-28
5
667 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
ID: 39606181
Do you know what all ports is uses?
0
 
LVL 10

Expert Comment

by:PadawanDBA
ID: 39606601
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
ID: 39609303
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
ID: 39609372
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
ID: 39619696
I fixed this issue myself after some further testing.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

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.
If you get continual lockouts after changing your Active Directory password, there are several possible reasons.  Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
This Micro Tutorial will teach you the basics of configuring your computer to improve its speed. It will also teach you how to disable programs that are running in the background simultaneously. This will be demonstrated using Windows 7 operating…
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.

932 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

14 Experts available now in Live!

Get 1:1 Help Now