Connecting to a Specific Port–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I recently blogged about finding the port your SQL Server uses. At the end of that post I showed a connection to a server using a port. This is something I’ve used rarely, but it’s been very helpful.

The specification for specifying a port can vary. For example, my build server at home runs TeamCity on port 8077. In my case, the URL to connect is:

http://192.168.1.201:8077/overview.html

If I had an FQDN, I might have this instead:

http://Atlas.dkranch.net:8077/overview.html

When I connect to SQL Server, I get this dialog:

2016-11-15 15_28_10-Connect to Database Engine

Some of you might note there is a “Connection Properties” tab, but there’s no port setting there, even if you choose TCP/IP.

2016-11-15 15_28_27-Connect to Database Engine

When I connect, I give a server name. In the example above, I used “.\SQL2016”. The default is that my client will try to connect on 1433 or use the SQLBrowser to get the port. However, I could specify the instance name like this:

.\SQL2016, 1433

For this instance, that wouldn’t work as the port is 6077. I’d have to write this:

.\SQL2016, 60087

But since I’m choosing a port, I don’t need that. I can use

.,60087

and I’ll connect.

Learn to use the port in your connection string. At some point, this will help you to troubleshoot connection issues.

#SQLNewBlogger

This is a quick, easy post to write. It’s five minutes work for most of you. Maybe 10 if you have to Google/Bing.

About way0utwest

Editor, SQLServerCentral
This entry was posted in Blog and tagged , , . Bookmark the permalink.