Others: SQL - How to check SQL Port No

From AutoCount Resource Center

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

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1

IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS

Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations