Specify a port number when connecting to SQL Server in Management Studio

Published on September 1, 2016 by abundantcode

Filed under SQL Server

Last modified September 1, 2016

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 419 times

There are times when you want to connect to a SQL Server instance that is running on a different port number than default port (1433).

How to specify a port number when connecting to a SQL Server instance in SQL Management Studio ?

Just specify the SQL Server instance that you are connecting to along with the port number with comma as delimiter.

For example , assume that the SQL Server is running on the machine ABUNDANTCODE-SERVER and runs on the port number 8001 , you will be specifying the server as ABUNDANTCODE-SERVER,8001


If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Comment


You might be Interested in these Posts

How to hide horizontal or vertical scroll bar using VBA Code in Excel ?

Here's a VBA code that hides the horizontal and vertical scroll bar in Microsoft Excel. How to hide...

Deleting all the hidden rows and columns in the active worksheet using VBA

Do you want to delete all the hidden rows and columns in the active worksheet in Microsoft Excel usi...

Displaying all the worksheet names in Excel using VBA Code

Do you want to display the names of the worksheets in the excel workbook ?. Here;s how you can do it...