Re: Named pipe error 53



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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:68D2C2C3-B0B1-4756-BBBD-B6A6D2577EDA@xxxxxxxxxxxxxxxx
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?

.



Relevant Pages

  • Re: Connectivity Issues - Bizzare
    ... Sounds like firewall to me. ... >I am trying to connect to a default instance of SQL Server 2000 Enterprise ... I create a SqlDataAdapter on the web form, ... I take the same connection string from the web app, ...
    (microsoft.public.sqlserver.connect)
  • Re: An error has occurred while establishing a connection to the server
    ... there is no problem with sql connection with pages out of this folder. ... SQL Server 2005, by default, the named pipes provider is not enabled. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Cant access Sql Server Express 2005
    ... I installed Sql Server 2005 Express and am trying to open a connection ... I enabled TCP/IP and Named Pipes and then rebooted. ... An error has occured while establishing a connection to the server. ... (provider: Named Pipes Provider, ...
    (microsoft.public.sqlserver.setup)
  • Re: Connect to SQL Server over the internet
    ... connection dialog window that you will find on the main menu: ... which is the port used by SQL-Server in its basic configuration. ... I can remove the firewall. ... Computer A is where is installed SQL server 2000 and the BE. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: SQL Server Service Mgr, Version 8.00.2039
    ... An error has occurred while establishing a connection to the ... When connecting to SQL Server 2005, this failure may be caused by ... Is this SQL program stopping this program from accessing the internet? ...
    (microsoft.public.sqlserver.server)

Loading