Summary
This Error Message Article explains the BACKTRACK error message “Unable to connect to the database: A network-related or instance-specific error occurred…SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified…” 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. There are several scenarios that can cause a connection problem including:
- SQL server is not functioning, not available, or configured incorrectly
- Window update stopped (and did not restart) a critical SQL service (e.g. the SQL Server instance or SQL Server Browser) and thus us unable to find the SQL instance
- The network traffic to or from the SQL server is blocked
- BACKTRACK SQL server settings are incorrect
Solution
The location for the license information can be found on the BACKTRACK server at c:\programdata\Teklynx\BACKTRACK\btwdata.ini
- Confirm that SQL Server is online
- 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 database
Additional Comments
Issue Found On: Windows 7 and 8 running BACKTRACK 2012
Related Articles:
BACKTRACK client workstation unable to locate SQL database when opening – KBA-01099-R7L5C3