Showing posts from October, 2011

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

Specifying a port number on SSMS is pretty easy Under the server name , specify the server(or ip)\instanceName, ( comma) port eg: 10.10.10.151\SQL2008,1433 Another way is to setup an alias in…

Finding the Port Number for a particular SQL Server Instance

One of the developers recently asked me this question: “I have a SQL Server instance running – how can I tell what port it is running on?”.  There are a couple of ways of finding this information. …
Subscribe Our Newsletter