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


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