How to connect AxTraxPro server to remote or not default SQL server
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:
- AxTraxNG DB (AxTrax1) DBO rights

- 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:
- Server - SQL server Address and instance name
- Database - database name - default AxTraxPro1 - recommend to keep default name
- Integrated security
- ON - use windows authentication
- Off - use SQL authentication
- User ID - SQL user ID
- Password - SQL user password
- First Run = need top be set to ON!!

Once all done restart the AxTraxNG service
Couldn't find what you are looking for?
Please feel free to contact us:
NORTH AMERICA & CANADA
Toll Free: 1 866 632 1101
Telephone: 1 817 305 0006
EUROPE
Telephone: 972 4 9577 183
LATIN AMERICA
Telephone: 54 11 4001 3104
APAC, MIDDLE EAST AND AFRICA
Telephone: 852 2795 5630
CHINA
Telephone: 86 755 8610 6842
INDIA
Telephone: 91 20 40147830