{"id":531,"date":"2024-08-14T09:52:57","date_gmt":"2024-08-14T09:52:57","guid":{"rendered":"https:\/\/www.hyderabadwebhosting.co.in\/tutorials\/?p=531"},"modified":"2024-08-14T09:56:55","modified_gmt":"2024-08-14T09:56:55","slug":"configure-sql-server-to-listen-on-a-specific-tcp-port","status":"publish","type":"post","link":"https:\/\/www.hyderabadwebhosting.co.in\/tutorials\/configure-sql-server-to-listen-on-a-specific-tcp-port\/","title":{"rendered":"Configure SQL Server to listen on a specific TCP port"},"content":{"rendered":"

This article describes Configure SQL Server to listen on a specific TCP port and how to configure an instance of the SQL Server Database Engine to listen on a specific fixed port by using SQL Server Configuration Manager. If enabled, the default instance of the SQL Server Database Engine listens on TCP port 1433. Named instances of the Database Engine and SQL Server Compact are configured for dynamic ports. This means they select an available port when the SQL Server service is started. When you connect to a named instance through a firewall<\/a>, configure the Database Engine to listen on a specific port, so that the appropriate port can be opened in the firewall.<\/p>\n

The Database Engine begins listening on a new port when restarted. However the SQL Server Browser service monitors the registry and reports the new port number as soon as the configuration is changed, even though the Database Engine might not be using it. Restart the Database Engine to ensure consistency and avoid connection failures.<\/p>\n

\n
\n
\n

Table of Contents<\/p>\nToggle<\/span><\/path><\/svg><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n