How Do I Find My SQL Server Port

Table of Contents

• Summary
• Finding The Port SQL Server Is Using

Summary

This guide will take you through figuring out which port your SQL Server is  using. 

Finding The Port SQL Server Is Using

In order to find the port your SQL Server you will need to have SQL Server Management Studio installed on the computer.

1. Open SQL Server Management Studio and connect to your SQL Server instance.
   
2. Open the Management and SQL Server Log tabs. Right-click Archive #1 and select View SQL Server Log.
   
3. Click the Filter button on the top toolbar.
   
4. Click in Message contains text box and type in "listening". Then, left-click the Apply filter checkbox and press OK.
   
5. You will want to look for a log entry, where the Message column says "Server is listening on ['any'  <ipv4> #####]."
   The ##### in the message instead will be the port your MyoVision SQL Server is using.