<div>
Do you know what all ports is uses?
</div>


<div>
What ports did you allow in windows firewall? &nbsp;Also, is this a default instance or a named instance of SQL server?
</div>


What ports did you allow in windows firewall?  Also, is this a default instance or a named instance of SQL server?

<div>
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.
</div>


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.

<div>
I fixed this issue myself after some further testing.
</div>


I fixed this issue myself after some further testing.

<div>
<div class="content wysiwyg-content">
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). <br />
<br />
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.<br />
<br />
Anyone got any ideas?<br />
<br />
Cheers! Sam
</div>
</div>


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

Windows Firewall blocking SQL over VPN.

Windows 7 is an operating system from Microsoft. Features include multi-touch support, a redesigned Windows Shell with a new taskbar, referred to as the Superbar, a home networking system called HomeGroup, and performance improvements.

Windows 7

Small Business Server (SBS) is a line of server operating systems targeted at small businesses by bundling the operating system with a number of other Microsoft products that would normally need to be purchased or licensed separately. The most notable inclusions are Exchange, SQL Server, SharePoint and ISA/TMG (Microsoft's firewall and proxy server).

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.