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
Solved

Windows Firewall blocking SQL over VPN.

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
By default the complete memory dump option is disabled in windows . If we want to enable the complete memory dump for a diagnostic purpose, we have a solution for it. here we are using the registry method to enable this.
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…
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum editing capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.

809 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