sqlserver 2005连接超时使用bat命令解决

发布时间：2023-08-04 14:18:29 所属栏目：MsSql教程来源：

导读：将以下内容保存为 opensql.bat 双击运行即可

<div class="codetitle"><a style="CURSOR: pointer" data="59605" class="copybut" id="copybut59605" onclick="doCopy('code59605')"> 代码如下:

将以下内容保存为 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 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

（编辑：聊城站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!