Issue
Using Apollo engineering software and receive an error 'Login failed for user 'Andover97'.
Environment
Apollo v3.1
Continuum
Cause
The wrong user credentials are used, Apollo is expecting a standard password. This authentication can fail if the password is different to the default or if SQL is set to for case sensitive passwords.
Resolution
It is possible to rectify by performing the following using the Apollo software.
1. Select the option 'Change Database' under the 'Edit' menu.
2. Select 'Non Standard Logon' and try different user name and password combinations, clicking 'Test' to check if the login works. It should be one of the following combinations unless the Continuum SQL install master password has been changed.
(removed due to public access)
*Try each variation of the default username and password with uppercase first letter and lowercase first letters.
3. When the test in step 2 works, click on the 'Change Database' button to set the new database. Unfortunately this is not saved and it will need to be re-entered each time Apollo is started.