To enable ports initially we have to determine wether the ports are
dynamic or static to do his follow this procedure...
A)How to determine if you are using a static or a dynamic port
If you are not sure if you are using a dynamic port, follow these
steps:1. Click Start, and then click Run.
2. In the Run dialog box, type regedit, and then click OK. This
will start Registry Editor.
3. Locate the HKLM/Software/Microsoft/MSSQLServer/MSSQLServer/
SuperSocketNetLib/Tcp/TcpDynamicPorts registry key. Use this key to
determine if dynamic ports are enabled. If it lists a numeric value,
that value is the last dynamic port value that was used by SQL
Server. If it is blank, you are using a static TCP port.
4. Quit Registry Editor.
B)How to enable TCP/IP with dynamic ports
If you are using dynamic ports, you must create an exception for the
SQL Server program in Windows Firewall.
For more information about how to create an exception for the SQL
Server program in Windows Firewall, click the following article
C)How to enable TCP/IP with a static port
To enable TCP/IP connectivity for SQL Server listening on a static
port, you must first know the number of the port that SQL Server is
using. To find the port, you can either use the Server Network
Utility or use the Regkey method.
Use the Server Network Utility to find the port that SQL Server is
using
Note This method works for either a default instance or for a named
instance.1. If you are using the Server Network Utility, click
Start, point to All Programs, point to Microsoft SQL Server, and then
click Server Network Utility. If you are using MSDE or the command
line, click Start, and then click Run. In the Run dialog box, type
svrnetcn.exe, and then click OK.
2. In the Server Network Utility dialog box, you will see a list
of the disabled protocols and a list of the enabled protocols on the
General tab.
3. In the Instances on this server list box, select the instance
that you want to examine.
4. Click to select the protocol that you want to find the port
number for, and then click the Properties button.
5. Make a note of the port number.
