Home MicrosoftWindows ServerSharepoint SQL 2008 R2 Firewall ports for SharePoint 2010

SQL 2008 R2 Firewall ports for SharePoint 2010

by Jón Ólafsson

 

Got a SQL 2008 R2 server and firewall is blocking acces from SharePoint 2010 to the SQL server…

Here is a script to open the firewall ports that I found online that you run on the server that is running SQL 2008 R2

Paste in Notepad and save the file with .bat extension and run it on the server that is hosting SQL 2008 R2 server.

REM Core SQL Services

REM Default Instance
netsh advfirewall firewall add rule name=”SQLServer” dir=in action=allow protocol=TCP localport=1433

REM Dedicated Admin Connection
netsh advfirewall firewall add rule name=”SQL DAC” dir=in action=allow protocol=TCP localport=1434

REM Browser Service
netsh advfirewall firewall add rule name=”SQL Browser” dir=in action=allow protocol=UDP localport=1434
REM Non Core Components
REM Dedicated Admin Connection
netsh advfirewall firewall add rule name=”SQL DAC” dir=in action=allow protocol=TCP localport=1434

REM Mirroring EndPoint
netsh advfirewall firewall add rule name=”Mirroring EndPoint” dir=in action=allow protocol=TCP localport=5022

REM Service Broker
netsh advfirewall firewall add rule name=”SQL Service Broker” dir=in action=allow protocol=TCP localport=4022

REM Enable TSQL Debugger — note, this is the same port as RPC
netsh advfirewall firewall add rule name=”T-SQL Debugger” dir=in action=allow protocol=TCP localport=135

REM Browser service for Analysis Services
netsh advfirewall firewall add rule name=”SQL Browser for Analysis Services” dir=in action=allow protocol=TCP localport=2382

REM Analysis services Default Instance
netsh advfirewall firewall add rule name=”Analysis Services” dir=in action=allow protocol=TCP localport=2383

REM HTTP/HTTPS for reporting services
netsh advfirewall firewall add rule name=”HTTP Reporting Services” dir=in action=allow protocol=TCP localport=80
netsh advfirewall firewall add rule name=”HTTPS Reporting Services” dir=in action=allow protocol=TCP localport=443

Hvað finnst þér?

You may also like

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.