windows 2008上启用防火墙后 sqlserver 2005连接超时的解决办法

[SqlException (0x80131904): 在与 SQL Server 建立连接时出现与网络相关的或特定于实例的错误。未找到或无法访问服务器。请验证实例名称是否正确并且 SQL Server 已配置为允许远程连接。 (provider: SQL 网络接口, error: 40 - 定位指定的服务器/实例时出错)]   昨日将sqlserver2005从windows2003迁移到windows2008系统上后，发现经常打开网页时提示sql server连接超时，但是有时候又是正常的，一开始一直以为是网络连接不好，后来发现超时时，远程连接完全正常，所以排除了这一因素，查看防火墙，发现1433端口tcp,udp也是允许通过的，无奈只能百度，发现在windows2008上除了1433，还有其它端口需要打开，这里把网上的资料整理了一个批处理文件,大家把下面的内容保存成openSql.bat，以管理员身份登录windows2008后双击运行即可 @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

转载于:https://www.cnblogs.com/chjun2000/archive/2012/04/26/2471804.html