How to use SQL with windows authentication

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: 
  1. 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.  
  2. Under the SQL section, set Integrated_Security value to true:
    Integrated_Security=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.
  1. Open windows services
  2. location the AxTraxNG server Service
  3. Right-click on AxTraxNG server service and click "Propertice"
  4. Navigate to "Log On" tab
  5. Select "this account" and enter the windows user and password to use the SQL authentication: 

  6. Click Apply 
  7. right-click AxTraxNG server and click Restart  Service
Now AxTraxNG should use windows authentication to login the SQL server.