Re: Named Pipes Provider, error 40 Could not open a connection to

It's not ports, it's "Connections". It might be a license restriction as
well...

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"JMLA" <JMLA@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CB4C9FE7-A3F2-4720-B163-0DF2784C952E@xxxxxxxxxxxxxxxx
Hi William Vaughn,

I have upgraded the MaxUserPort in the registry to 40000, and nothing
happens, any ideas?

Thanks in advance,
Miguel.

"William (Bill) Vaughn" wrote:

I have seen this before in SQL Servers that have been configured to
support
N connections and no more. In this case, the named pipe is opened (the
Connection) but the server finds that the connection limit has been
reached
so it closes the pipe at the server end. This confuses the connection
pooler
who responds that the named pipe has failed and the connection could not
be
opened after all.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no
rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"JMLA" <JMLA@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FFF29A16-3C52-4596-AC88-F18D41E31309@xxxxxxxxxxxxxxxx
Hi,

I have a big problem, I have a website in a Windows 2003 and SQL Server
2005, and the website usually goes weel, but some times and error
appears,
the error is "Named Pipes Provider, error: 40 - Could not open a
connection
to SQL Server".

There is not installed a firewall and TCP and Pipes connection are
enabled.

Any ideas?

Thanks in advance,
Miguel





.

Relevant Pages

  • Re: Connection using IP vs. hostname (which one is better for prog
    ... "William (Bill) Vaughn" wrote: ... Hitchhiker’s Guide to Visual Studio and SQL Server ... which one is faster and reliable in term of connection? ...
    (microsoft.public.sqlserver.connect)
  • Re: How migrate from SQL Express to SQL Server
    ... William Vaughn ... Hitchhiker's Guide to Visual Studio and SQL Server ... I expect that all you'll need to do is detach/reattach the database and change the connection string. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL Connection Strings
    ... "William Vaughn" wrote: ... the query plan is not going to change based on rights. ... What makes you think the SP or SQL Server will get confused? ... See Chapter 9 in my book or my blog for more info on connection issues ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Named Pipes Provider, error 40 Could not open a connection to SQL
    ... the named pipe is opened (the ... Connection) but the server finds that the connection limit has been reached ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ...
    (microsoft.public.sqlserver.connect)
Loading