How to specify a non-standard SQL TCP port for connection

The default TCP port that SQL server listens on is 1433.  If you want to specify a different port for connection, here's the general steps.

  1. Change the SQL server instance to listen on a different port.
  2. Ensure that the new port is not blocked by the firewall
  3. Enter the new port after the normal SQL server name\instance name.  {servername}\{sqlinstance}, {port}

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Article is closed for comments.