1433 ports on SQL Server 2005 open and connect remotely

Reference Address: http://topic.csdn.net/u/20090828/16/e693935a-99b7-4090-a6bc-0123c91183eb.html

1. How to open the 1433 port of SQL Server 2005

Configuration Tool->sql Server configuration Manager->mssqlserver Protocol

See if the TCP/IP protocol starts, if it starts, right-click on the "Properties" menu, select "IP Address" in the paging menu, "TCP port" in "IP1" and "IP2" to 1433,

"Enabled" Changes to "yes"

Configuration Tool->sql Server configuration manager->sql Native client-side protocol->TCP/IP

Select "Properties" in the TCP/IP right-click menu to confirm that "default port" is 1433, "enabled" is "yes"

2. SQL Server 2005 Remote Connection

Configure TCP/IP properties.
Surface area------and Remote Connections--->using tcp/it

SQL Server Surface Area Configuration-service and connectivity perimeter configuration-database englie-remote connection-enabled (remote connection TCP/IP and Named pipes)
SQL Server Configuration manager-sql2005 network Configurations-enable TCP/IP and Named pipes

Set the above through the client or the connection is not on NND

It seems to be out must kill skill, so contacted million network technical support small mm

The must kill technique see: