Sql Server 2005 安装后 TCP/IP 配置
错误：The TCP/IP connection to the host localhost, port 1433 has failed. Error: Connection refused: connect. Please verify the connection properties and check that a SQL Server instance is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.
解决方案：
1.查看SQL Server Express 2005 网络配置信息（SQL Server 2005 Network Configuration――> Protocols for SQLEXPRESS）。默认的情况下右边列表中的Named Pipes和TCP/IP的状态为Disable，即没有启用。右键点击这两项，在弹出菜单中选中Enable启用这两个协议;
2.IP1、Ip2和IPALL 的端口设置为1433，”活动“和”已启用“都选”是“，是否全部侦听并不影响结果
页:
[1]