Others: SQL - How to check SQL Port No

From AutoCount Resource Center
Revision as of 06:54, 19 February 2020 by LaySwan (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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?

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

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