Some questions never cease to come up on various forums. The most common of them seems to be: What TCP/IP port is my SQL Server listening on? In today’s post, I will quickly demonstrate two simple ways to answer this question.
Launch the SQL Server configuration manager using one of the following ways:
The second method that I am about to demonstrate now, involves reading the SQL Server error log through the SQL Server Management Studio. This can be achieved using T-SQL queries also, and if you are interested, do leave a comment and I will cover that in one of my future posts.
This entry contains the port number on which the SQL server is listening to.
I hope you found this post useful. In my next post, I tackle one of the other most frequently asked questions – “Can I connect to my SQL Sever named instance using the IP address and/or TCP/IP port number?”
Until we meet next time,
Be courteous. Drive responsibly.
Tags: #SQLServer, SQL Server, Administration, Development, DBA, Tools and Utilities, Tips