1. Home
  2. Inventory and Item Tracking Software
  3. BACKTRACK
  4. BACKTRACK Error Messages
  5. “Unable to connect to database: Connection timeout expired” – BACKTRACK Error Message

“Unable to connect to database: Connection timeout expired” – BACKTRACK Error Message

Summary

This Error Message Article explains the BACKTRACK error message “Unable to connect to database: Connection timeout expired” and details how to fix the underlying problem that caused it to appear.

Explanation

There is a communication problem between client workstation (BACKTRACK) and SQL server the system where the data for BACKTRACK is stored.  In most instances, that will be the SQL server.  If you are using Microsoft Access, it could mean that the server where the BACKTRACK databases are stored is not accessible (down or having connectivity issues).

Solution

If this has been a working system:

Confirm that the database is online.  In SQL cases, make sure that the server is on and the databases are mounted.  In Microsoft Access case, make sure that the server is online and the databases are in the location that is reachable by the workstation running BACKTRACK.

If you encounter this is after the installation:

SQL:

  • Confirm that SQL Server is online (service is running):
  • Confirm that the the SQL Server Network Configuration has Shared Memory, Named Pipes and TCP/IP Enabled.
  • The firewall at SQL server is correctly set (using standard port)
  • Confirm that the user has appropriate permission for the databases.

Microsoft Access:

  • Confirm that the server is online
  • Confirm that the ‘share’ for the databases is valid
  • Confirm that the user has appropriate permissions to the share

Additional Comments

Issue Found: on Windows Server 2012, SQL Server 2014 running BACKTRACK 2012

Updated on July 28, 2017

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support