Sunday, December 19, 2010

Connect to your SQL server

A simple script that enables connection to your default SQL server on port 1433. Works on XP, Vista, Win 7, 2003, 2008, and 2008 R2

Copy the content to notepad and save the file as .bat

---------------------------------------------------------------------------------------------------------

@rem Easy Firewall-script for enabling connetion to default SQL

@echo = SQL Server Ports =
@echo SQLServer default instance port 1433
netsh firewall set portopening TCP 1433 "SQLServer"

@echo Dedicated Admin Connection port 1434
netsh firewall set portopening TCP 1434 "SQL Admin Connection"

@echo SQL Server Service Broker port 4022
netsh firewall set portopening TCP 4022 "SQL Service Broker"

@echo Transact-SQL Debugger/RPC port 135
netsh firewall set portopening TCP 135 "SQL Debugger/RPC"

@echo = Analysis Services Ports =
@echo SSAS Default Instance port 2383
netsh firewall set portopening TCP 2383 "Analysis Services"

@echo SQL Server Browser Service port 2382
netsh firewall set portopening TCP 2382 "SQL Browser"

@echo = HTTP, SSL, Browser, and Multicast =
@echo HTTP port 80
netsh firewall set portopening TCP 80 "HTTP"

@echo SSL port 443
netsh firewall set portopening TCP 443 "SSL"

@echo SQL Server Browser Service's 'Browse' Button
netsh firewall set portopening UDP 1434 "SQL Browser"

@echo Allowing multicast broadcast response on UDP (Browser Service Enumerations OK)
netsh firewall set multicastbroadcastresponse ENABLE


---------------------------------------------------------------------------------------------------------

No comments: