How to change the default port for SQL Server named instances?

Question

The idea is to make your named instance appear as the Default instance. Open SQL Server Configuration Manager. Navigate to: SQL Server Network Configuration -> "Protocols for XYZ" treenode. Right-click on the TCP/IP item in the right pane. Choose Properties menu item. On Protocol tab, ensure Enabled is set to Yes.

How do I change the default port for SQL Server?

Solution1Run the SQL Server Configuration Manager.2Select the SQL Server Network Configuration.3Select from the list the instance you want to configure to listen to on a specific port.4To change the port assignment right-click on the TCP/IP protocol and select Properties.5Click on the IP Addresses tab.

How do I change the default port in SQL Server 1433?

Steps1Change the port in the SQL Server Configuration Manager, and under the TCP/IP which has the layer of the IP v4 , v6 etc, and change the port accordingly.2Then, the port number is only changed on the TCP port level at the SQL configuration.3Change the page name, login.

What is the default port of a SQL Server default instance?

Global default Port is a TCP port setting that our client network libraries use to connect to a 'Default' instance of SQL Server. By default, this port is set to 1433 (in line with the installation of SQL Server 'Default' instance with the default setup options).

What port is SQL Server named instance?

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.

Expert · Answer