Welcome to my World of SQL

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…

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. …