SQLState 080001 error 17 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQLState 080001 error 17

Hi I have too servers A and B Need to create ODBC connection from A to B and getting errror:
View Message Thread (8 replies) Results 1 – 9 of 9 ODBC Error Connecting to SQL
From: Jaz
Date Posted: 5/30/2005 4:26:00 AM I very clear that i configured SQL database with no problem but while i going
to setup DSN in ODBC and this error occured, I do not understand what is the
problem that keep this error exist.

Connection failed:
SQLState: ‘01000’
SQL Server Error: 2
[Microsft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (connect()).
Connection failed:
SQLState: ‘08001’
SQL Server Error: 17
[Microsft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist
or access denied. I can ping server B perfectly fine from A.
Also any other PC makes the ODBC connection to A without any problems
Any idea will be appritiated.
Thank you
I would refer this KBAhttp://support.microsoft.com/default.aspx?scid=kb;EN-US;Q328306 and take the measures defined there. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Hello dear, I have exactly the same problem. When you get the solution, could you let me know. I really appriciate it. Thanks, Babr

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |