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
Enhanced by Zemanta

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s