Ensure the following:

  1. The system ODBC connection (ex: RE7_1) is using the same connection method (ex: Windows or SQL Authentication) as the user account (ex: REUSER) on the database
  2. If using Windows authentication, the user account logged into the workstation or server must have sufficient rights to the database
  3. If using SQL Authentication ensure that the SQL user password has not changed and is entered correctly in the system ODBC connection
  4. The recommended connection method for the SQL server is Mixed Authentication which allows for both Windows and SQL connections to the SQL server
  5. Detach and then Reattach the database from the Blackbaud Management Console