Solved

Windows Firewall blocking SQL over VPN.

Posted on 2013-10-28
5
687 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

What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

Question has a verified solution.

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

A quick step-by-step overview of installing and configuring Carbonite Server Backup.
When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no back…
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…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

734 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