In my last blog “SQL Server runs on which port?” we discussed about the Defualt and Dynamic Port.
Now the question is how to find Dynamic Port reserved by SQL Server, I know your answer would be we’ll simply go and check the details through SQL Server Configuration Manager.
But what if you don’t have RDP Access to SQL Server?
If you don’t have RDP Access you can check the Dynamic Port No. reserved by SQL Server through SQL Server Error Log.
Now if you read the SQL Server Errorlog, you’ll find an entry “Server is listening on <49179>”.
In this row value 49179 is the port no. assigned to SQL Server normal connections & for DAC Connections SQL Server is listening on port 49180.
Since i am using Windows 7 there are two entries one for IPV4 and other one for IPV6. Please refer the Screenshot below:
Learn SQL & related technologies from top-notch experts. 3 days. 30+ speakers. 70+ sessions. Join Asia’s first SQL Conference.