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.
  • Ensure that the new port is not blocked by the firewall
  • 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

    0 Comments

    Article is closed for comments.