Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    1

    Unhappy Unanswered: Failed client connection by name\name.

    Attempting ODBC connection to SQL Server by MachineName\SqlServerName doesn't work.
    Can only connect by using IP address of server machine with name of SQL Server instance.
    Any help would be appreciated.
    thanks

  2. #2
    Join Date
    Feb 2004
    Location
    Egypt
    Posts
    12
    Please refer to the following url, it may help you:
    http://www.able-consulting.com/MDAC/...erForSQLServer

  3. #3
    Join Date
    Feb 2004
    Location
    PAKISTAN
    Posts
    106
    Rather than SQL-Server, can u access that machine by name from the client? It also happens bcz of WINS entry or if the Server is in DMZ etc. If u can't access the server over the LAN by name, edit ur client's HOSTS file.

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Add the entry in LMHOSTS file and if its still timeouts then ensure proper value is defined on SQL server to login timeout.

    Also ensure similar protocols are enabled between client & server.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •