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.
Assumptions & Disclaimer:
- This post demonstrates an administrative procedure that deals with SQL Server instance security. Please do not perform the steps outlined in this post without consulting your database administrator
- It is assumed that the SQL Server under question is configured for accepting remote connections via TCP/IP protocol
Method 01: Using the SQL Server Configuration Manager
Launch the SQL Server configuration manager using one of the following ways:
- Go to Start –> Programs –> Microsoft SQL Server 2012 –> Configuration Tools –> SQL Server Configuration Manager
- Go to Start –> Run –> “SQLServerManager11.msc”
Method 02: Reading the SQL Server Error Log
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,