How to connect AxTraxPro server to remote or non-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 AxTraxPro server to a remote or not  a default SQL server please follow this guide.

As General Rosslare recommend that SQL sys admin (sa) user and password will not be provided 

Please make sure that the SQL user provide has the following permissions:

1. AxTraxPro DB (AxTraxPro1) DBO rights
   
   
2. Master DB VIEW SERVER STATE rights
   
   

Once an SQL user is created you will need to import the AxTraxPro DB into the  SQL server, please contact the DB admin and provide him with a backup of the AxTraxPro database (in case of active installation) or a  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 
   
1. User ID - SQL user ID 
   
2. Password - SQL user password
   
4. First Run = must be set to ON
   

Save the configuration by clicking the save button, 

Once all done restart all AxTraxPro services

• Related Articles

• How to install SQL server (AXTRAXPRO instance) Manually

  In some cases, the Automatic installation of SQL Server on the machine might fail due to conflicts or other issues; in those cases, we recommend installing SQL Server manually. This Article will show you how to install a SQL Server (Express Edition) ...

• How to connect AxTraxPro server to remote 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? Preparing for Remote SQL connection: To connect the AxTraxPro server to a remote SQL ...

• 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 Starting version 28.0.4.0 AxTraxPro supports the above SQL servers with addition: MS-SQL 2022

• How to install and set AxTraxPro remote client

  When a remote AxTraxPro client connection is needed to AxTraxPro server you can achieve this in few simple steps: Please note that AxTraxPro server and AxTraxPro client Must use the same version Please set the firewall rules on AxTraxPro server ...