How to Fixed this Sql server Network Error

Posted by Jayakumars under Sql Server on 4/24/2017 | Points: 10 | Views : 264 | Status : [Member] [MVP] | Replies : 1
Hi

I have delete and recreate Odbc DSN in this time i meet this issue.how to fixed this?


Connection Failed;
SQLState:'01000'
SQL Server Error:10060
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen
(Connect()).
Connection failed;
SQLState:'08001'
SQL Server Error:17
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied

Mark as Answer if its helpful to you


Responses

Posted by: Bandi on: 4/27/2017 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Refer this link, make sure that the Named pipes and TCIP protocols enabled.
https://serverfault.com/questions/82007/how-do-i-get-this-sql-server-odbc-connection-working

check whether Named Pipes and TCP/IP protocols are getting disabled automatically whenever network goes down?

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response