批處理打開SQL端口

打開SQL 2012 2008 所需端口

建立一個txt文本檔案，并雜裡面粘貼如下内容：

@echo ========= SQL Server Ports ===================

@echo Enabling SQLServer default instance port 1433

netsh firewall set portopening TCP 1433 "SQLServer"

@echo Enabling Dedicated Admin Connection port 1434

netsh firewall set portopening TCP 1434 "SQL Admin Connection"

@echo Enabling conventional SQL Server Service Broker port 4022

netsh firewall set portopening TCP 4022 "SQL Service Broker"

@echo Enabling Transact-SQL Debugger/RPC port 135

netsh firewall set portopening TCP 135 "SQL Debugger/RPC"

@echo ========= Analysis Services Ports ==============

@echo Enabling SSAS Default Instance port 2383

netsh firewall set portopening TCP 2383 "Analysis Services"

@echo Enabling SQL Server Browser Service port 2382

netsh firewall set portopening TCP 2382 "SQL Browser"

@echo ========= Misc Applications ==============

@echo Enabling HTTP port 80

netsh firewall set portopening TCP 80 "HTTP"

@echo Enabling SSL port 443

netsh firewall set portopening TCP 443 "SSL"

@echo Enabling port for 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

儲存，并把txt文本檔案更改為bat字尾，成為批處理檔案。

右鍵以管理方式運作此批處理檔案

     本文轉自cantgis 51CTO部落格，原文連結：http://blog.51cto.com/cantgis/1191026，如需轉載請自行聯系原作者