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

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
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@.discussions.microsoft.com> wrote in message
news:FFF29A16-3C52-4596-AC88-F18D41E31309@.microsoft.com...
> 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
|||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@.discussions.microsoft.com> wrote in message
> news:FFF29A16-3C52-4596-AC88-F18D41E31309@.microsoft.com...
>
>
|||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@.discussions.microsoft.com> wrote in message
news:CB4C9FE7-A3F2-4720-B163-0DF2784C952E@.microsoft.com...[vbcol=seagreen]
> 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:
sql

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

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,
MiguelI 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@.discussions.microsoft.com> wrote in message
news:FFF29A16-3C52-4596-AC88-F18D41E31309@.microsoft.com...
> 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

n00b Question Re: MSDE SQL Server Install

I am trying to install some code on my website which is called EasyDisk. It
creates a forum, like any forum you see anywhere. Anyways it requires an SQL
Server, so I acquired MSDE SQL Server 2000. I created an instance of it, and
can see the folder on my C drive. The instance is called
MYFIRSTDBMSSQL$MYFIRSTDB oddly enough since I guess I didn't understand the
instruction for naming an instance. In any case, the forum software requires
I know 1. The name of my SQL Server, 2. My username 3. My password and 4. My
database name.
So, best I can tell my db name is my instance name, and my username and
password are what I use to log onto Windows XP. How far off am I? ... and I
have no idea what my sql server name is. How do I find out? The Books online
is no help whatsoever in this regard.
Thanks,
Jim
hi Jim,
"newgenre" <newgenre@.mindspring.com> ha scritto nel messaggio
news:%xchc.3922$e4.2441@.newsread2.news.pas.earthli nk.net...
>.....
> I know 1. The name of my SQL Server, 2. My username 3. My password and 4.
My
> database name.
> So, best I can tell my db name is my instance name, and my username and
> password are what I use to log onto Windows XP. How far off am I? ... and
I
> have no idea what my sql server name is. How do I find out? The Books
online
> is no help whatsoever in this regard.
your instance name shoul'd be MYFIRSTDB (and you can verify this opening
your service management applet, in the part right to the $ sign)... the
service manager in your tray bar area shoul'd provide this information
too...
so the full instance name is YourComputerName\MYFIRSTDB
your db name for the connection string is not the instance name, but the
database you want to connect to..
as regard your credential, it depends on the authentication mode you want to
connect to SQL Server with..
SQL Server accepst 2 kinds of authentication mode:
trusted (WinNT) authentication, where you are not required to provide user's
information;
SQL Server authentication, where you have to provide them in the form of
"user id=username;password=yourStrongPwd;" as indicated in
http://www.connectionstrings.com/ ...
you can find more about authentication modes beginning at
http://msdn.microsoft.com/library/de...setup_6p9v.asp
you can find which kind of authentication your MSDE instance supports by
inspecting the registry at the
HKLM\Software\Microsoft\Microsoft SQL
Server\YourInstanceName\MSSQLServer\LoginMode key
a value of 0 or 2 specifies Mixed mode (both modes), while a value of 1
spefies truste authentication only.
hth
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql

n00b question - permissions from website

Hi everyone,

I've inherited a website based on the dotnetnuke frameowork.

this website also uses the reporting services from sqlserver.

When the report button is clicked in the website, the user is prompted

with a login and password (standard windows dialog)

Entering the username/password for the web site fails,

entering username/password for the machine works.

The user - of course - doesn't want to enter enything, let alone see the darn dialog box,

just wants to see the report on the screen.

Does anyone have any ideas on where to start looking for a solution to this problem?

thanks

tony

The settings for the permissions of the report service are in the service's properties in IIS settings in control panel -> administrative tools. You might be able to set it to use the same password as the rest of the website there.