How to use SQL with windows authentication
By default, the AxTraxNG server will use the SQLinternal user logins (sa user) as set by the default AxTraxNG installer.
In some cases, you might be needed to use windows authentication for SQL login, there are some requirements needed to be done to allow this.
For SQL user permission requirements please review this ARTICLE
Enable Windows Authentication login
To enable windows authentication login please follow those steps:
- You need to edit the iniSQL file that can be found on the AxtraxNG server installation folder; C:\Program Files (x86)\Rosslare\AxTraxNG Server
the iniSQL file can be edited by notepad application.
- Under the SQL section, set Integrated_Security value to true:
Set AxTraxNG server Service to run under windows user
To make sure that the AxTraxNG server service uses the windows authentication you need set the login under the server setting.
- Open windows services
- location the AxTraxNG server Service
- Right-click on AxTraxNG server service and click "Propertice"
- Navigate to "Log On" tab
- Select "this account" and enter the windows user and password to use the SQL authentication:
- Click Apply
- right-click AxTraxNG server and click Restart Service
Now AxTraxNG should use windows authentication to login the SQL server.
How to connect AxTraxPro server to remote or not default SQL server
Before starting this process please make sure that the SQL server meets AxTraxPro server supported SQL servers. Which versions of SQL Server does AxTraxPro support? To connect the AxTraxNG server to a remote or note a default SQL server please ...
How to install SQL server (VERITRAX instance) Manually
On some cases the Automatic installation of SQL server on the machine might fails due to conflicts found on the machine or other issues, in those cases we recommend that SQL server will be installed manually. This Article will show you how to install ...
Dual Authentication on AxTraxNG
AxTraxNG support 2 options for dual Autentication: Dual authentication - 2 credentials (any credential\pin) from the same user are required to gain access to a secure door. Card + Card mode - 2 or 3 users (based on configuration) are required to gain ...
Install AxTraxNG\ AxTraxPro on Windows 11 OS
Lately there are multiple report on SQL server fails to be installed on Windows 11 OS, following the information provided by Microsoft the most common issue for this failure is system disk sector size greater than 4 KB. in any case of installing ...
Which versions of SQL Server does AxTraxPro support?
AxTraxPro server supports the following versions of MS-SQL servers: MS-SQL 2019
Couldn't find what you are looking for?
Please feel free to contact us:
NORTH AMERICA & CANADA
Toll Free: 1 866 632 1101
Telephone: 1 817 305 0006
Telephone: 972 4 9577 183
Telephone: 54 11 4001 3104
APAC, MIDDLE EAST AND AFRICA
Telephone: 852 2795 5630
Telephone: 86 755 8610 6842
Telephone: 91 20 40147830