Solved

Windows Firewall blocking SQL over VPN.

Posted on 2013-10-28
5
691 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
A quick guide on how to use Group Policy to create a custom power plan and set it active on Windows 7.
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 create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…

630 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