How to Find the Dynamic Port reserved by SQL Server?

Who is online?  211 guests and 0 members
home  »  blogs  »  Sarabpreet Anand  »  How to Find the Dynamic Port reserved by SQL Server?
  Rate This Blog Entry:  register  or  login


sarab Sarabpreet Anand (Member since: 3/15/2011 5:38:06 AM)
SQLServer-MVP, Vice President -

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  Twitter@Sarab_SQLGeek ,  Facebook ,  LinkedIn

View Sarabpreet Anand 's profile

Comments (1)

11/15/2013 5:13:40 PM Amitav said:

Hi Sarabpreet,


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

Email:  (your email is kept secure)

example: ""

Type the characters:

SQLServerGeeks FaceBook group

SQLServerGeeks Events

Training on Microsoft Products & Technologies

Email Subscriptions

   Get the Most Recent Blogs in your inbox
Blogs RSS Feed

Sarabpreet Anand's latest blog posts

Blogs RSS Feed

Latest community blog posts

  • Hi Friends, In my earlier blog, I just explain about the importance of filtered indexes. Link for that blog is mention below:
  • A few words about the technology of our site. It's easy to take technology for granted, to focus on content and pay no attention to how it is being delivered. Typically we would encourage this focus. ...
  • Hello, Constraints can be defined as rules that govern the values that are inserted into a column. These rules help in enforcing data integrity. For example if a NOT NULL constraint is defined over a ...