To resolve the problem, you will need to first troubleshoot the ODBC connection and if the problem is not resolved, test the Database Connection string described below:

Check the ODBC connection as follows:
​
Type Win-S and search for ODBC.
​

Select Set up ODBC data sources (32-bit).
​
The ODBC Data Source Administrator screen appears.

Select the System DSN tab and click on aps_dsql database name.
​

Hit the Configure button.
​

Hit the Next button.
​

Ensure both ANSI boxes are not ticked.

Hit the Finish button.
​

Run the Test Data Source.
​

Ensure the TESTS COMPLETED SUCCESSFULLY and click OK.
​

Hit OK to the ODBC Data Source Administrator screen.
​

If/When all tests are complete successfully check if you can log on to APS application successfully.
​
If the problem persists, check the Configuration File Setup
​

From the Adv2000 folder, locate the aADBConf.exe file and double left click.
​

Check there is a connection string available on the Enter database connection string field.
​

If the connection string is missing, copy and paste the string from a working PC.
​
Click the Save button and select the Yes option on the screen below.
​

Hit OK on the Save screen.
​

Hit the Close button on the Advance database Configuration File Setup screen.
​
Test whether you can open Advance Central Login and log in.
​

Further to point 2 above, open aaDBConf.exe in the C:\ADV2000 folder and ensure that Enable Encryption is ticked, and that Enable quick server locator is un-ticked.
​

Click on Start, Administrative Tools, Services.
​

Then in the Services window, look for SQL Server.
​
Check that the Log On As setting on the right is Local System, not Network Service.
​

If it is set to Network Service, then right click on the service and go into Properties.
Then in the Log On tab, tick the radio button for Local System account.
​

If there is already an ODBC connection in place, try deleting it and create a new one.