Question

sql2005 1433端口怎么打开

Answer 1

配置工具->Sql
Server Configuration Manager->MSSQLSERVER的协议
看看TCP/IP协议是否启动,如果启动,右键菜单点"属性"
,在分页菜单中选"IP地址",把"IP1"和"IP2"中"TCP端口"为1433, "已启用"改为"是"

配置工具->Sql
Server Configuration Manager->SQL
Native Client 配置->客户端协议->TCP/IP
选择TCP/IP右键菜单中"属性",确认"默认端口"是1433,"已启用"为"是"

配置TCP/IP属性.
Surface Area Configuration
-->
Database Engine --> Remote Connections
--->Using TCP/IT
SQL Server 外围应用配置器—服务和连接外围配置—database

englie—远程连接—启用(远程连接的TCP/IP和named
pipes) SQL Server Configuration
Manager—SQL2005网络配置—启用TCP/IP和named
pipes