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

Post a Comment

Specifying a port number on SSMS is pretty easy

Under the server name , specify the server(or ip)\instanceName, ( comma) port


Another way is to setup an alias in Config Manager. Then simply type that alias name when you want to connect. This makes it much easier and is more prefereable when you have to manage several servers/instances and/or servers on multiple ports and/or multiple protocols. Give them friendly names and it becomes much easier to remember them.

Related Posts

There is no other posts in this category.

Post a Comment

Subscribe Our Newsletter