SQL Server Performance

SQLState 080001 error 17

Discussion in 'General DBA Questions' started by NewDBA, Jun 23, 2005.

  1. NewDBA New Member

    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

  2. satya Moderator

  3. babrha New Member

    Hello dear,

    I have exactly the same problem. When you get the solution, could you let me know. I really appriciate it.

    Thanks,

    Babr

Share This Page