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 follow this guide.

As General Rosslare recommend that SQL sys admin (sa) user and password will be provided to allow connection to the remote SQ: server, if a sys admin 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\AxTraxPro Server\DB_Clear:

Once the DB has been imported into the SQL run the AxTraxPro Configuration Tool as administrator and  go to the "Settings" section:

The following setting needs to be applied for remote\ non default SQL connection: 

1. Server - SQL server Address and instance name 
   
2. Database - database name - default AxTraxPro1 - recommend to keep default name 
   
3. Integrated security 
   
1. ON - use windows authentication 
   
2. Off - use SQL authentication 
   
4. User ID - SQL user ID 
   
5. Password - SQL user password
   
6. First Run = need top be set to ON!!
   

Once all done restart the AxTraxNG service

• Related Articles

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

• Which versions of SQL Server does AxTraxPro support?

  AxTraxPro server supports the following versions of MS-SQL servers: MS-SQL 2019

• How to upgrade from AxTraxNG to AxTraxPro

  This technical note gives the procedure to upgrade from AxTraxNG™ v27.7.1.18 or above to AxTraxPro™ v28.0.x.x. Upgrade to AxTraxPro is only available from AxTraxNG version 27.7.1.18 and above, if your version of AxTraxNG lower then AxTraxNG version ...

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

• What are the minimum requirements for AxTraxPro Server, Web Server, and Client installation

  The minimum spec for AxTraxNG Server and Client as listed in the manual are: CPU: 2.4GHZ (i5) or higher OS: win 10 or higher, up to win server 2019 is supported. RAM: 8GB (min 12GB is recommended) Network: network adapter 100MB Hard Drive: 500 GB ...