Error: (399 [08001]) Error in ProcessClientSync. System.Data.Odbc.OdbcException...SQL Server does not exist or access denied...

Scenario

You may get 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 message
(
399
) Error in ProcessClientSync. System.Data.Odbc.OdbcException: ERROR [
08001
] [Microsoft][ODBC SQL Server Driver] ...
SQL Server does not exist or access denied
. ERROR [
01000
] [Microsoft][ODBC SQL Server Driver] ... ConnectionOpen (Connect()). at GFR_LookuplistSync.Database.Execute(String strSQL, String strDelimiter) at GFR_LookuplistSync.SyncLookuplist.ProcessClientSync(IniFile& objIniFile)

Cause

These errors may be caused by any of the following:
  • The account for the Lookup List Sync service does not have proper permissions.
  • The password has expired on the account used for the Lookup List Sync service.
  • The server hosting the time and billing database is offline.
  • The time and billing database has moved to a different server than where it was when the lookup list and the ODBC data source were originally set up.
  • A change to the firewall is not allowing the connection to the time and billing database.
  • Settings for the time and billing database server have changed and no longer allow remote connections.
  • The name of the time and billing database has changed.
  • The login defined in the ODBC connection to the time and billing database has failed.

Solution

Try these recommended solutions in the following order:
  • Verify that the Lookup List Sync service is using an account with administrator privileges on the Log on tab of the service.
  • Verify that the password for the Lookup List Sync service account has not expired.
  • Verify that the server hosting the client database is online.
  • Verify that you are connected to the database server.
  • Review the SQL server troubleshooting article for resources and information on configuring the Practice CS SQL database.

error-icon

error-close