Others: SQL - How to check SQL Port No

From AutoCount Resource Center
Jump to navigation Jump to search

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


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

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