What is the default port of sql server & Can we change the default port, if so where can we change it?

Question

Accepted Answer

The default port of SQL Server is 1433. Yes, we can change the default port by modifying the SQL Server Configuration Manager.

The default port for SQL Server is 1433.
To change the default port, open SQL Server Configuration Manager.
Navigate to SQL Server Network Configuration and select Protocols for the desired SQL Server instance.
Right-click on TCP/IP and choose Properties.
In the IP Addresses tab, scroll down to the IPAll section.
Change the TCP Port value to the desired port number.
Restart the SQL Server service for the changes to take effect.

Accepted Answer

TCP1433 4022, 135, 1434, UDP 1434.

Go to Start > programs > Microsoft SQL Server > Configuration Tools > SQL configuration manager > expand SQL Network Configuration > Protocols for 'instancename' > right click tcp\ip > IP addresses tab > Put a custom port number in the TCP PORT section right at the bottom. Restart SQL Server instance.

Accepted Answer

TCP1433 4022, 135, 1434, UDP 1434.

Go to Start > programs > Microsoft SQL Server > Configuration Tools > SQL configuration manager > expand SQL Network Configuration > Protocols for 'instancename' > right click tcp\ip > IP addresses tab > Put a custom port number in the TCP PORT section right at the bottom. Restart SQL Server instance.

What is the default port of sql server & Can we change the default port, if so where can we change it?

Top DXC Technology MS SQL DBA interview questions & answers

Popular interview questions of MS SQL DBA

Top HR questions asked in DXC Technology MS SQL DBA

What is the default port of sql server &amp; Can we change the default port, if so where can we change it?

Top DXC Technology MS SQL DBA interview questions & answers

Popular interview questions of MS SQL DBA

Top HR questions asked in DXC Technology MS SQL DBA

What is the default port of sql server & Can we change the default port, if so where can we change it?