Using a filter to move contacts to an archive database but getting an error: "MS ADO Connection: Login failed for user sa"

Version 1

    Details

    Using a filter to move contacts to an archive database but getting an error: "MS ADO Connection: Login failed for user SA"


    Resolution

    This means the database you are trying to move records to does not have the correct sa password stored in the DBalias.ini
    To update the password for this database:

    1. Tools > Databases > Alias Manager
    2. Highlight the Database Alias and click Edit
    3. Update the password for the sa account
    4. Click TEST connection to ensure it works
    5. Click OK to save settings

    Additional Note: The error message and resolution may apply to any MS SQL user account and does not necessarily need to be the sa account