时间:2021-05-23
将以下内容保存为 openSql.bat 双击运行即可
复制代码 代码如下:
@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
声明:本页内容来源网络,仅供用户参考;我单位不保证亦不表示资料全面及准确无误,也不保证亦不表示这些资料为最新信息,如因任何原因,本网内容或者用户因倚赖本网内容造成任何损失或损害,我单位将不会负任何法律责任。如涉及版权问题,请提交至online#300.cn邮箱联系删除。
环境:-Apache2.2.6-PHP5.2.5-SQLServer2005-WindowsXPSP2步骤:1.首先按通常做法配置好PHP5连接MSSQLSer
ASP.net连接SQL2005数据库出现错误提示:在建立与服务器的连接时出错。在连接到SQLServer2005时,在默认的设置下SQLServer不允许进行
SQLServer2005远程连接配置TCP/IP属性.SurfaceAreaConfiguration–>DatabaseEngine–>RemoteConn
本文实例讲述了PHP5.6.8连接SQLServer2008R2数据库常用技巧。分享给大家供大家参考,具体如下:用到的工具:1.JetBrainsPhpStor
了解SQLServer2005数据库的朋友可能都知道,tempdb系统数据库是一个全局资源,可供连接到SQLServer2005实例的所有用户使用。我们有时