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
