Q: After successfully creating the TRAINTRACK database in SQL and double checking that all installation steps in the documentation were completed, the client computer is still unable to connect to the Server. When creating the ODBC, the error message returned is "Connection Failed: SQL State 08001".

A:

Solution 1: Ensure that a firewall is not blocking ports 1433, 1434

Solution 2: Confirm that TCP Dynamic Ports is blank and that listed ports are 1433, 1434. To do this:

1. Open the SQL Configuration Manager and expand SQL Server Network Configuration.
2. Double-click on Protocols for MSSQLSERVER .
3. Right-Click on TCP/IP and select Properties.
4. Click the IP Addresses tab.
5. Confirm that TCP Dynamic Ports is blank and TCP port is set to 1433, 1434.
6. Open Control Panel > Administrative Tools > Services and restart the SQL Server.

Tags: ODBC, connect to server, connect to SQL.