A2.120 : POS How to check Microsoft SQL instance port number?

A2.120 : POS How to check Microsoft SQL instance port number?

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..


    --Source from AutoCount Wiki --

      • Related Articles

      • A2.109 : How to configure dynamic and static sql port number?

        Question : How to configure dynamic and static sql port number for security purpose as I do not want to open all my ports? Solution : User may configure sql port number in SQL Server configuration manager. Using SQL Port number to link up system, may ...
      • A2.108 : How to set windows firewall exception for sql port?

        Question : How to set windows firewall exception for sql port? Solution : User may need to set windows firewall exception for sql port if user unable to link up Autocount system by using sql port. 1. Press Win + R to open run command, and fill in ...
      • A2.70 : How to Enable POS Credit Control?

        Question : In Accounting system we can set credit control for debtor, how about POS? If yes, how to trigger credit control on POS? Solution : Yes, AutoCount POS credit sales supports credit control. POS 3.1 : 1. Firstly set credit control for ...
      • A2.147 : How to check my Dongle/USB key number

        Question : How can I know my Dongle / USB key serial number? Solution : POS 3.0/3.1: 1. Windows Start Menu > AutoCount POS > AutoCount POS Dongle Checker 2. Make sure dongle already inserted > click Check. For POS 5.0/FnB: 1.Go to partner space to ...
      • A2.32 : How to resync one specific pos transaction by using SQL query command?

        Question : How to resync one specific pos transaction by using SQL query command? Solution : Dealer discretion is advised. This SQL query command can only be executed at POS Frontend. Pos3/5/FNB: How to resync one specific pos transaction by using ...