Post reply

SQL Server does not exist or access denied

  • April 21, 2005 at 11:06 am

    #85864

    I am using ODBC SQL and when I use the IP of the Server, it connects.

    When I use the Server Name, it fails with the following

     

    Connection failed:

    SQL State: '01000'

    SQL Server error: 10061

    [Microsoft][]ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()).

    connection failed:

    SQL State: '08001'

    SQL Server Error: 17

    [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Sql Server does not exist or access denied.

     

     

  • April 21, 2005 at 12:09 pm

    #554179

    It might be a DNS issue.  Can you PING the server using its name?

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • April 22, 2005 at 2:15 am

    #554284

    Is your ODBC connection set to use TCP/IP or has it defaulted to named pipes?

    --
    Scott

  • April 22, 2005 at 10:00 am

    #554373

    Is the server in the DMZ?  If so it will not resolve the name.  You will have to use the IP.

  • April 22, 2005 at 10:37 am

    #554385

    I can ping using the name; the server is not in a DMZ....When I use the cmd 'telnet servername 1433', could not open connection to host using port

  • April 28, 2005 at 3:47 am

    #555471

    Try setting SQL Client to Named Pipes only.

    Possible that TCP/IP config (as in windows server auto-update).

    Also check service pack version and security version since related to connectivity.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply