Pos3/Pos5/FNB: POS How to check Microsoft SQL instance port number?

From AutoCount Resource Center
Jump to navigation Jump to search

Question :

I want to open firewall port setting for AutoCount system, how can I know which port number is used by AutoCount?


Solution :

1st way is you can use AutoCount SQLUtility.exe to check

If normal store in AutoCount Full Setup CD > SQLUtility.exe

000100-a.png


Click Run

000100-b.png


Set instance > Check > TCP Port will find out (No. is 49802) > Open Microsoft Windows X Firewall ( if you need it help you open port in windows firewall)

000100-c.png


Set instance:

Instance Name: A2006 this normal is use AutCount CD setup (is AutoCount System Default instance Name)

Instance Name: SQLExpress this normal is user manual setup (is Microsoft Default instance Name)

Other Instance Name Other if you have use owns instance name need change the Other name.

000100-d.png


OK done set

000100-e.png


2nd way is open Microsoft Configuration Manager

You need now what Microsoft SQL Server version you using.

Windows Start > Microsoft SQL Server 20XX > SQL Server Configuration Manager

000100-f.png


If you can’t find this you can go to Windows Run/Search > key in the file name (slqservermanager11.msc)

000100-g.png


More info for SQL Version & file name matching.( https://docs.microsoft.com/en-us/sql/relational-databases/sql-server-configuration-manager?view=sql-server-ver15)

SQL Server Network Configuration > Protocols for A2006 > TCP/IP > IP Addresses > IPALL** (Port number Autoount using) > OK for close

000100-a.png

TCP Dynamic Ports: this column port number is system auto provide it also will auto changing.

TCP Port: this column port number is human control & prefix only have someone to change it.

Now we get the AutoCount system port number we can doing open security system firewall port No..



By: CK 200917, Jacky 200922, Peter 200930 [000100]


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