sqlserver 2005连接超时采用bat命令解决
前端之家收集整理的这篇文章主要介绍了
sqlserver 2005连接超时采用bat命令解决，
前端之家小编觉得挺不错的，现在分享给大家，也给大家做个参考。
将以下内容保存为 opensql.bat 双击运行即可
<div class="codetitle"><a style="CURSOR: pointer" data="59605" class="copybut" id="copybut59605" onclick="doCopy('code59605')"> 代码如下:
<div class="codebody" id="code59605">
@echo =========
sql Server Ports ===================
@echo Enabling
sqlServer default instance port 1433
netsh firewall set port
opening TCP 1433 "
sqlServer"
@echo Enabling Dedicated Admin Connection port 1434
netsh firewall set port
opening TCP 1434 "
sql Admin Connection"
@echo Enabling conventional
sql Server Service Broker port 4022
netsh firewall set port
opening TCP 4022 "
sql Service Broker"
@echo Enabling Transact-
sql Debugger/RPC port 135
netsh firewall set port
opening TCP 135 "
sql Debugger/RPC"
@echo ========= Analysis Services Ports ==============
@echo Enabling SSAS Default Instance port 2383
netsh firewall set port
opening TCP 2383 "Analysis Services"
@echo Enabling
sql Server Browser Service port 2382
netsh firewall set port
opening TCP 2382 "
sql Browser"
@echo ========= Misc Applications ==============
@echo Enabling HTTP port 80
netsh firewall set port
opening TCP 80 "HTTP"
@echo Enabling SSL port 443
netsh firewall set port
opening TCP 443 "SSL"
@echo Enabling port for
sql Server Browser Service's 'Browse' Button
netsh firewall set port
opening UDP 1434 "
sql Browser"
@echo Allowing multicast broadcast response on UDP (Browser Service Enumerations OK)
netsh firewall set multicastbroadcastresponse ENABLE
