I have a workstation running SQL Server 2005 with mixed mode. I have enabled
remote access and allowed access through the firewall. All of the remote
workstations can connect, but one. I have tried to to an ODBC test connect
and it gives me the following error.
Connection failed:
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server does not exist or
access denied.

I have tried changing it between Named Pipes and TCP/IP and it does not work
on both. The other workstations use Named Pipes and have no problems.

What could block one workstation?

Try pinging the server by server name and IP address -
whichever you are using for the connections - but still do
both. If you are using server names and the ping by server
name doesn't work, you have a DNS issue.
Next thing to check would be to verify the MDAC installation
for the client you are having problems with. You can
download the component checker to do this. Component checker
and recent MDAC versions can be downloaded from:
http://msdn.microsoft.com/data/ref/mdac/downloads/

-Sue

On Wed, 25 Oct 2006 09:26:03 -0700, Matt Soukup
<MattSoukup (AT) discussions (DOT) microsoft.com> wrote: