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

As General Rosslare recommend that a "sa" user and password will be provided to allow connection to the remote SQL server, if a "sa" user is not available please make sure that the SQL user provide has the following permissions:

1. AxTraxPro DB (AxTraxPro) 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 remote SQL server, please contact the DB admin and provide him with a backup of the AxTraxPro 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:

File Name: DBClear_AxTraxPro1_v23.bak

Configurating SQL server Connection details: 

Once the DB has been imported into the SQL server you need to configure the SQL connection settings using the AxTraxPro configuration toll.

Once all done start AxTraxNG service

1. Run the AxTraxPro Configuration toll as "Administrator"
   
   
2. Open the "Setting Section:
   
   
3. Set the Flowing data: 
   
1. server - set the SQL server Address\ Instance Name
   
2. database - set the database name if imported under deferent name than default 
   
3. Integrated_security - for using SQL login ser to off
   
4. user_id - set the user name to login the SQL server 
   
5. password - the passwords used to login the SQL server 
   
6. First Run - for first connection set to On.
   
4. You can also replace the connection string if you have a valid connection string and avoid the above manual settings.
   
5. Click the save button 
   
6. Restart the AxTraxPro server service. 

• Related Articles

• 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 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 configure AxTraxPro Web Client for remote access

  The Rosslare AxTraxPro™ Web Client software is a web-based software management system intended for the ongoing management of the AxTraxPro™ Server. Operators can access the system from a web browsers for daily tasks. The AxTraxPro access control ...

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