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.
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.