Named pipe error 53

I get the following error when I try to connect from an XP SP2 client to SQL
MSDE:
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to
SQL Server) (Microsoft SQL Server, Error: 53)
Before last week, al worked fine, but suddenly I get this message.
What goes wrong?Is the service on another machine ? Can you reach the computer via ping ?
Did you try disabling the firewall on the Windows XP machine to see if it is
dedicted to the settings of the firewall ?
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
--
"Johan" <Johan@.discussions.microsoft.com> wrote in message
news:68D2C2C3-B0B1-4756-BBBD-B6A6D2577EDA@.microsoft.com...
>I get the following error when I try to connect from an XP SP2 client to
>SQL
> MSDE:
> An error has occurred while establishing a connection to the server. When
> connecting to SQL Server 2005, this failure may be caused by the fact that
> under the default settings SQL Server does not allow remote connections.
> (provider: Named Pipes Provider, error: 40 - Could not open a connection
> to
> SQL Server) (Microsoft SQL Server, Error: 53)
> Before last week, al worked fine, but suddenly I get this message.
> What goes wrong?sql

Named Instance not Displaying Only Server Name

I have a Dell Latitude D505 running a fresh copy of XP SP2. I am trying to
create an ODBC System DSN to our SQL 2k server. The SQL Server has about 6
instances installed on it. When I pull down the drop down box to select a
server, only the server name exists, but none of the instances. This is
working on 180 desktops configured off the same image of XP.
Basically, I am seeing:
<Server Name> instead of <Server Name>\<Instance>
<Server Name>\<Instance 2>
Just so you know, I have already updated the MDAC version, so that cannot
be the issue.
|||This is all set now. My issue was the wireless network being enabled. As
soon as I disabled it, it worked fine.

Named Instance not Displaying Only Server Name

I have a Dell Latitude D505 running a fresh copy of XP SP2. I am trying to
create an ODBC System DSN to our SQL 2k server. The SQL Server has about 6
instances installed on it. When I pull down the drop down box to select a
server, only the server name exists, but none of the instances. This is
working on 180 desktops configured off the same image of XP.
Basically, I am seeing:
<Server Name> instead of <Server Name>\<Instance>
<Server Name>\<Instance 2>Just so you know, I have already updated the MDAC version, so that cannot
be the issue.|||This is all set now. My issue was the wireless network being enabled. As
soon as I disabled it, it worked fine.