Error Creating a ODBC datasource for SQL-Server

 

While i was trying to create an connection to my server using ODBC database connection, i came across the following error.

 

Connection failed
SQL State '01000'
SQL Server error 53
[microsoft][ODBC SQL Server Driver][DBNETLIB]Connection Open
Connection failed
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