Error: (399 [42000]) Error in ProcessClientSync. System.Data.Odbc.OdbcException... Cannot open database requested in login...

Scenario

You may receive an email with the following error message multiple times per day. You may also notice the Lookup List Sync is not working properly and find this error in the log files.

Error messages

(399) Error in ProcessClientSync. System.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login '<gfr_login>'. Login fails. ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login '<gfr_login>'. Login fails. at GFR_LookuplistSync.Database.Execute(String strSQL, String strDelimiter) at GFR_LookuplistSync.SyncLookuplist.ProcessClientSync(IniFile& objIniFile)

Causes

These errors may be caused by any of the following:

  • The name of the time & billing database has changed.
  • The login defined in the ODBC connection to the time & billing database has failed.
  • The server hosting the time & billing database is offline.
  • The time & billing database has moved to a different server than where it was when the lookup list and ODBC data source were originally set up.
  • A change to the firewall is not allowing the connection to the time & billing database.
  • Settings for the time & billing database server have changed and no longer allow remote connections.

Solutions

Try these recommended solutions in the following order.

  • Test the ODBC datasource and update passwords or database names as necessary.

    Review the ODBC Connection to a Database article for information on ODBC connections.

  • Verify that there is an entry for GoFileRoom under System DSN for ODBC connections.
  • Verify that the server with the time & billing client database is online.
  • Verify that you are connected to the time & billing application database server.

    Review the SQL server troubleshooting article for resources and information on configuring the Practice CS SQL database.


Related articles

How to install the Lookup List Sync utility

Troubleshooting GoFileRoom Lookup List Sync errors

Was this article helpful?

Thank you for the feedback!

Internal only

(399) Error in ProcessClientSync. System.Data.Odbc.OdbcException: ERROR [42000] may also indicate there is no sysadmin administrator login for the SQL instance. Support representatives may encounter this when setting up the Lookup List Sync on their own computers. If there is no account with the sysadmin role, you can add one in Microsoft SQL Management Studio by following these steps:
  1. Open Microsoft SQL Management Studio.
  2. Connect to the applicable server instance.
  3. Expand the Security folder.
  4. Right-click the Logins folder and choose New Login.
  5. On the General page of the Login dialog, enter BUILTIN\Administrators in the Login name field.
  6. Click the Server Roles page, and mark the sysadmin checkbox.
  7. Click OK.
  8. Stop and then restart the service for the change to take effect.