Enable to create ODBC Connection to SQL Server 2008 Express

After hours of trying to connect to my SQL Server 2008 Express install I  came across this Post. Thank you Mr. Luangaroon, you have save me more hours of searching through the  Microsoft site.

If you are receiving the following message, or one similar to it (error 53, 67, 17..etc) while trying to make an ODBC connection to your SQL Server, take a look at the steps on this post. It helped me.

Connection failed:
SQL State: ‘01000’
SQL Server error: 11001
[microsoft][ODBC SQL Server Driver][TCP/IP

Sockets]ConnectionOpen (Connect()).
Connection failed:
SQL State: ‘08001’
SQL Server Error: 6
[microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified

SQL Server not found.

Click here –> Linglom’s blog

Advertisement