How to Fixed this Sql server Network Error

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Kumaraspcode2009@gmail.com

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

Latest Posts