| Sue Hoegemeier 2006-10-26, 12:14 am |
| 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@discussio
ns.microsoft.com> wrote:
>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?
|