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?


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

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