Others: SQL - How to check SQL Port No

Question: When installing SQL Server manually, what are the port numbers or exceptions that I should add into firewall rules or antivirus exception?

Version: 1.8 / 1.9 / 2.0


Answer:

1. Click on Windows button and search for SQL Server Configuration Manager.


Sql port.png


2. Go to SQL Server Network Configuration, select Protocols, right click on TCP/IP/ Properties.


Sql port2.png


3. Search for TCP Dynamic Ports. Now, you may add the TCP dynamic port for SQL Server into Firewall rules or antivirus exception.


Sql port3.png


By:Ella 170714,KM 170810; P170810


Go to menu

  AutoCount Accounting 2.0


  AutoCount Accounting 1.8 / 1.9
  AutoCount Payroll
  AutoCount POS


  AutoCount On The Go
  AutoCount Accounting Plug-In Documentations