6/25/2011 8:26:00 PM
Sarabpreet Anand -
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:
Sarabpreet Anand (Member since: 3/15/2011 5:38:06 AM)
SQLServer-MVP, Vice President - SQLServerGeeks.com
Sarabpreet is SQLServer MVP, DBA, Speaker, Trainer, Blogger and Community Lead. You can find him speaking at a local UG Event or a SQL Webcast. He has 8+ years of Experience and worked with Industry Leaders like Wipro, HP and HCL. He has many SQL Certifications under his belt. His core competency lies in administration of SQL Server. Always ready to help, online \offline. His life’s mantra is “Knowledge Increases by sharing so, Pass it on”. To know about his speaking engagements visit: here...
Follow Sarab on
View Sarabpreet Anand 's profile
Is there any place in SQL server where it stores the static and dynamic port numbers. I need to run a query whcih would retrieve the numbers. I know you can look into the configuration manager/Event Viewer/Error logs. But does sql store the information in any sys tables?
The sys.dm_exec_connections contains on the static port numbers but i want both.
Leave a comment