Knowledge Base
cancel
Showing results for 
Search instead for 
Did you mean: 

Specify a TCP port for the communication between Vista and the SQL server

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.

  1. Start the SQL Configuration Manager
  2. Expand SQL Server Network Configuration
  3. Click on Protocols "Instancename"
  4. Click on TCP/IP and open the tab IP addresses
  5. Go to the bottom fields "IP All" take away everything in the field  "TCP Dynamic port"
  6. Specify a port which SQL should use in "TCP Port"
  7. Now open the Vista server setup
  8. 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. 
Tags (1)
Labels (1)
Version history
Revision #:
1 of 1
Last update:
‎2018-09-10 05:38 AM
Updated by: