<div>
Hi mhamer<br />
<br />
&nbsp;Please run below command. or chek the link please<br />
<br />
<br />
netsh firewall set portopening protocol = TCP port = 1433 name = SQLPort mode = ENABLE scope = SUBNET profile = CURRENT<br />
<br />
A similar example using the Windows Firewall for Advanced Security helper:<br />
<br />
netsh advfirewall firewall add rule name = SQLPort dir = in protocol = tcp action = allow localport = 1433 remoteip = localsubnet profile = DOMAIN<br />
<br />
<br />
<br />
<a href="http://technet.microsoft.com/en-us/library/cc646023.aspx" rel="ugc">http://technet.microsoft.com/en-us/library/cc646023.aspx</a>
</div>


Hi mhamer

 Please run below command. or chek the link please


netsh firewall set portopening protocol = TCP port = 1433 name = SQLPort mode = ENABLE scope = SUBNET profile = CURRENT

A similar example using the Windows Firewall for Advanced Security helper:

netsh advfirewall firewall add rule name = SQLPort dir = in protocol = tcp action = allow localport = 1433 remoteip = localsubnet profile = DOMAIN



http://technet.microsoft.com/en-us/library/cc646023.aspx [http://technet.microsoft.com/en-us/library/cc646023.aspx]

<div>
the link to blog post had lots of good information
</div>


the link to blog post had lots of good information

<div>
<div class="content wysiwyg-content">
HI, building a sharepoint farm, on 2008 R2, with SQL 2008 and SHarepoint 2010<br />
<br />
The desihn insisist on the windows firewall being left on, &nbsp;but I cant seem to get the right ports.<br />
<br />
Do you know of any resources that could helo me with this please.<br />
<br />
what ports to open. would be a good start<br />
thank you
</div>
</div>


HI, building a sharepoint farm, on 2008 R2, with SQL 2008 and SHarepoint 2010

The desihn insisist on the windows firewall being left on,  but I cant seem to get the right ports.

Do you know of any resources that could helo me with this please.

what ports to open. would be a good start
thank you

FIREWALLPORTS for SQL 2008 cluster on windows 2008 R2

The Microsoft Legacy Operating System topic includes legacy versions of Microsoft operating systems prior to Windows 2000: All versions of MS-DOS and other versions developed for specific manufacturers and Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions, and Windows Mobile.

Microsoft Legacy OS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.