Switch TCP port in SQL server

  • For security reason, I am going to switch the default port to another port; the firewall has been opened between IIS (outside domain server) to internal SQL server. My question is that does this switch affect internal application connect to SQL server? Internal applications are using server name to connection to SQL server.

  • From memory, when you try to connect to a sql instance (including the default instance) by name, a request is sent to UDP port 1434 on the server. The server responds with the actual port number for that instance. I can't remember the name of the service that does this at present.

    Provided you can connect UDP port 1434 you should be OK.

  • You have to specify the port. there are two ways to do that.

    1.  Change the default port number for each client using the Client Network Utility. Highlight TCP/IP in the Enabled Protocols pane and click Properties. Change the port number.

    2.  You can specify the port number when connecting by adding ,port# to the server name. So instead on MyServer, you would specify MyServer,8599 to connect to port 8599.

     

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply