Multiple Browser Connection Problem

I'm having problems working on a DNN Site. I'm doing all the dev work local
on my machine. I've got SQL 2005 Developer Edition. I'm running a DNN site on
the local IIS. I've enabled both tcp and named pipe connections and I've
started the browser service. The web config is pointed to Server=(local).
Simply put I get the message
The page cannot be displayed
There are too many people accessing the Web site at this time.
I realize they don't want people running big-ol' web sites on this but come
one. I've simply got 3 browser windows open. I've got 2 on the local machine
and then I use remote desktop to view the page from another machine and
logged into the site as a test user while on my local machine I'm logged in
as a superuser making changes. I don't know what the heck is going on. I
don't know if changing it to TCP only or even specifying localhost instead of
(local) in the connection string. If anyone has a fix for this please let me
know. Honestly this is pretty silly on Microsofts part. If this is just
something you can't get around, one of those By design failures, Does anyone
know if there is an upgrade I can get from dev edition to standard (or
whatever marketing is calling it this year).
hi,
NetFodder wrote:
> I'm having problems working on a DNN Site. I'm doing all the dev work
> local on my machine. I've got SQL 2005 Developer Edition. I'm running
> a DNN site on the local IIS. I've enabled both tcp and named pipe
> connections and I've started the browser service. The web config is
> pointed to Server=(local). Simply put I get the message
> The page cannot be displayed
> There are too many people accessing the Web site at this time.
as the instance you are referencing is a default instance, there's no need
of the the SQL Browser service..

> I realize they don't want people running big-ol' web sites on this
> but come one. I've simply got 3 browser windows open. I've got 2 on
> the local machine and then I use remote desktop to view the page from
> another machine and logged into the site as a test user while on my
> local machine I'm logged in as a superuser making changes. I don't
> know what the heck is going on. I don't know if changing it to TCP
> only or even specifying localhost instead of (local) in the
> connection string. If anyone has a fix for this please let me know.
> Honestly this is pretty silly on Microsofts part. If this is just
> something you can't get around, one of those By design failures, Does
> anyone know if there is an upgrade I can get from dev edition to
> standard (or whatever marketing is calling it this year).
actually I do not think the problem is SQLExpress related, as SQLExpress
does not limit this way the max number of connections to the SQL Server
instance..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
|||Actually I did a bunch of research and found a couple of solutions for it.
First the developer edition also does not have a limit (programatically) on
the number of connections. However, for some reason my system did. After
fixing that by uninstalling/reboot/re-installing, I ran into an IIS
limitation. Most likely because I'm working on some modules that actually use
specified user accounts for running. They work kind of the same as SQL, or
exchange where the services need a service account to run. These need a web
account to run so think of them as DNN Service Accounts. Anywho, 2 pieces
together fixed it. First I used MetaEdit to change the IIS limit from 10 to
40. Then I unchecked the box on the web site properties page for KeepAlives.
If anyone runs into this, I hope this helps.
"Andrea Montanari" wrote:

> hi,
> NetFodder wrote:
> as the instance you are referencing is a default instance, there's no need
> of the the SQL Browser service..
>
> actually I do not think the problem is SQLExpress related, as SQLExpress
> does not limit this way the max number of connections to the SQL Server
> instance..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
> -- remove DMO to reply
>
>