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 Moderator http://www.SQL-Server-Performance.Com/forum 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