Issue
Is it possible to specify a TCP port for the communication between Vista and the SQL server?
Environment
- Vista 5.1.7
- SQL server 2008
Cause
The default SQL Server port is 1433, and client ports are assigned a random value between 1024 and 5000.
Resolution
It is possible to specify which port that should be used by the SQL server.
- Start the SQL Configuration Manager
-
Expand SQL Server Network Configuration
- Click on Protocols "Instancename"
- Click on TCP/IP and open the tab IP addresses
-
Go to the bottom fields "IP All" take away everything in the field "TCP Dynamic port"
- Specify a port which SQL should use in "TCP Port"
- Now open the Vista server setup
-
To specify which port Vista should use when communicating with the SQL server add a comma after the name of the SQL server and then enter the port number, in this case 27035 which also was specified in the SQL server.