While i was trying to create an connection to my server using ODBC database connection, i came across the following error.
SQL State ‘01000’
SQL Server error 53
[microsoft][ODBC SQL Server Driver][DBNETLIB]Connection Open
SQL State ‘08001
SQL Error 17
[microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
Selecting the ‘Name Pipes’ in the Network libraries did the trick.
Control Panel->Administrative Tools->Data Sources(ODBC ->ODBC Data Source Administrator -> Add->SQL Server
Configure Name: SQLServer Server: <servername> Click Next Click -> Client Configuration.. Network libraries -> Select Named Pipes