Pos3/Pos5/FNB: : How to configure dynamic and static sql port number?

From AutoCount Resource Center
Revision as of 05:22, 30 September 2021 by PeterT (talk | contribs) (Created page with "<u><b>Question :</b></u> How to configure dynamic and static sql port number for security purpose as I do not want to open all my ports? <u><b>Solution :</b></u> User may...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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 provide more stable connection between SQL Server and Autocount System.


1. Press Win + R to open run command, and fill in name as below if your SQL Server version is 2012

000248-a.png


2. Otherwise, User also can go to Start Menu to find SQL Server Configuration Manager .

000248-b.png


3. Go to SQL Server Network Configuration and expand it, and click on Protocol for A2006

000248-c.png


4. Right click TCP/IP and click enable.

000248-d.png


5. Make sure TCP/IP is Enabled before you can set the sql port number.

000248-e.png


6. Go back to SQL Server Services and select SQL Server (A2006) to restart the services.

000248-f.png


7. Right click again TCP/IP and select properties > IP Addresses tab and scroll it down to the bottom.

000248-g.png


8. Now you will see TCP Dynamic Ports is auto assigned by system default, But you also can assign a static SQL port number under TCP Port column.

000248-h.png


9. Make sure to click on OK button to save the setting. Go back to SQL Server Services and select SQL Server (A2006) to restart the services.


By: Kee 20210914, Jacky 20210921, P210927 [000248]


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