How to Specify port number for Server when connecting in SQL Management Studio ?

By default , the SQL Server listens to the port number 1433 and assume that if your server name is SENTHIL-LT and the database instance is SQLEXPRESS , you would specify the server name in SQL Management Studio as SENTHIL-LT\SQLEXPRESS.

If the SQL Server is configured to listen to a different port , for example 6262 .

How to Specify port number for Server when connecting in SQL Management Studio ?

You can add the comma in between the server and the port .

SENTHIL-LT\SQLEXPRESS , 6262

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 Reply


x

Interesting BlogPosts to read

Event on Building intelligent bots with the Microsoft Bot Framework in Manchester
Want to learn about building intelligent bots using Microsoft's Bot Framework. Here's an interesting...
Barracuda Introduces Email Threat Scan for Microsoft Office 365
With the number of advanced threats on the rise and affecting companies of all sizes, Barracuda toda...
Column Alias and Square brackets in SQL Query.
When we want to specify a alias for a column in SQL Query , we tend to use the double quotes or sing...