How do you specify a different port number in SQL Management Studio?

I am trying to connect to a Microsoft SQL 2005 server which is not on port 1433. How do I indicate a different port number when connecting to the server using SQL Management Studio?

How do I connect to a different port in SQL Server?

You can enter the different port on port number field. E.g with following screenshot, enter host name and the port number. If you need to connect to the non default port with SQL Server database, you need to use the syntax "serverName,portNumber" when connecting.

Can we change SQL Server port 1433?

1. Change 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. 2. Go to the MS Services then, look for the MS SQL services and restart them first to take an affect.

127.0.0.1,6283

Add a comma between the ip and port