ODBC Connect: timeout exceeded
Symptoms
When installing or upgrading the XIA Configuration Server you see the error "ODBC Connect: timeout exceeded".
Cause
There are several reasons
- The SQL Server instance name has been specified incorrectly.
- The SQL Server instance is not available over the network.
Resolution
- Ensure that the SQL server instance name has been specified correctly. When performing an upgrade the following registry keys are used for the instance and database name.
HKEY_LOCAL_MACHINE\SOFTWARE\CENTREL Solutions\XIA Configuration Server\Setup
DatabaseInstance (REG_SZ)
DatabaseName (REG_SZ) - Ensure that the SQL server instance is available.