Menu
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?
270
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.
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
156
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
