How to connect AxTraxNG server to remote SQL server

How to connect AxTraxNG server to remote SQL server

Before starting this process please make sure that the SQL server meets AxTraxNG server supported SQL servers.  Which versions of SQL Server does AxTraxNG support?

To connect the AxTraxNG server to a remote SQL server please follow this guide.
As General Rosslare recommend that a "sa" user and password will be provided to allow connection to the remote SQ: server, if a "sa" user is not available please make sure that the SQL user provide has the following permissions:
  1. AxTraxNG DB (AxTrax1) DBO rights

  2. Master DB VIEW SERVER STATE rights

Once an SQL user is created you will need to import the AxTraxNG DB into the remote SQL server, please contact the DB admin and provide him with a backup of the AxTraxNG database (in case of active installation) or a DB clear DB in case of new installation, you can find the clear DB in the following path: C:\Program Files (x86)\Rosslare\AxTraxNG Server\DB_Clear:

Once the DB has been imported into the SQL server you need to edit the iniSQL file that can be found on the AxtraxNG server installation folder;   C:\Program Files   (x86) \Rosslare\AxTraxNG Server with the following data:


Once all done start AxTraxNG service