"Too many requests being handled for user" error while accessing Report Manager

Hi,
When I try to access Report Manager(http://<reportserver>/Reports) I'm
getting the following error message:
"There are currently too many requests being handled for user:
[DOMAIN]\[USER]. Please wait until the current requests have finished
processing before issuing any more."
However there are no problems when I try to access the Report
Server(http://<reportserver>/ReportServer).
Has anyone encountered a similar situation before?
Thanks.
RamkiRestarting IIS resolves the issue. Increasing the
"MaxActiveReqForOneUser" in RSReportServer.config from its default of
20 might also be an option.
Ramki

"The request failed with HTTP status 401: Unauthorized."

Hi,
I'm having a few problems with getting SQL RS running and wondered
whether anyone could give me some help.
I have just installed RS and have never got into the Report Manager
yet. I think it is basically an IIS permissions problem as I am
getting a page that says "The request failed with HTTP status 401:
Unauthorized." whenever I try to get to
http://reporting.[domain].com/Reports, even if I add myself to the
domain Administrators group. I have all of the IIS settings as they
are specified in documentation.
My setup: Reporting Services SP2, IIS6, Windows 2003 Server, SQL Server
2000, installed on a non-default website following instructions on
SQLJunkies.com by Trent Miesner(although I'm pretty sure this isn't the
problem).
Thanks in advance,
SamJust check if this helps
http://support.microsoft.com/kb/896861/en-us
Sam wrote:
>Hi,
>I'm having a few problems with getting SQL RS running and wondered
>whether anyone could give me some help.
>I have just installed RS and have never got into the Report Manager
>yet. I think it is basically an IIS permissions problem as I am
>getting a page that says "The request failed with HTTP status 401:
>Unauthorized." whenever I try to get to
>http://reporting.[domain].com/Reports, even if I add myself to the
>domain Administrators group. I have all of the IIS settings as they
>are specified in documentation.
>My setup: Reporting Services SP2, IIS6, Windows 2003 Server, SQL Server
>2000, installed on a non-default website following instructions on
>SQLJunkies.com by Trent Miesner(although I'm pretty sure this isn't the
>problem).
>Thanks in advance,
>Sam
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200602/1|||As a few others have mentioned, the article(method 1) did fix my problem. I
had everything working but started getting this error when I required SSL in
the RS configuration/report server virtual directory configuration.
http://support.microsoft.com/kb/896861 I rebooted after doing it.
I'm using SQL2005 SP1 on Win2k3 SP1.
--Forrest
"BALAJI K via SQLMonster.com" wrote:
> Just check if this helps
> http://support.microsoft.com/kb/896861/en-us
>
>
> Sam wrote:
> >Hi,
> >
> >I'm having a few problems with getting SQL RS running and wondered
> >whether anyone could give me some help.
> >
> >I have just installed RS and have never got into the Report Manager
> >yet. I think it is basically an IIS permissions problem as I am
> >getting a page that says "The request failed with HTTP status 401:
> >Unauthorized." whenever I try to get to
> >http://reporting.[domain].com/Reports, even if I add myself to the
> >domain Administrators group. I have all of the IIS settings as they
> >are specified in documentation.
> >
> >My setup: Reporting Services SP2, IIS6, Windows 2003 Server, SQL Server
> >2000, installed on a non-default website following instructions on
> >SQLJunkies.com by Trent Miesner(although I'm pretty sure this isn't the
> >problem).
> >
> >Thanks in advance,
> >
> >Sam
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200602/1
>

"HTTP status 400: Bad Request" - Reporting Services 2005

Has anyone ran into this error yet while testing Report Manager?
"The request failed with HTTP status 400: Bad Request."
I can deploy and access reports directly, but I receive the above error when
hitting the http://localhost/Reports URL (i.e. ReportManager)
Also, I'm seeing DCOM errors in the NT event log whenever this happens. A
search in the registry find CLSID references to network components (Network
Connection Manager Class, Network Connection Manager Connection Enumerator
Class, LAN Connection Manager Class, etc). Any ideas? Is there a security
configuration that I'm missing?
Here's an example entry:
Event Type: Error
Event Source: DCOM
Event Category: None
Event ID: 10016
Date: 11/8/2005
Time: 8:23:48 AM
User: NT AUTHORITY\NETWORK SERVICE
Computer: *SERVERNAME*
Description:
The application-specific permission settings do not grant Local Activation
permission for the COM Server application with CLSID
{BA126AD1-2166-11D1-B1D0-00805FC1270E}
to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security
permission can be modified using the Component Services administrative tool.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.I have the same problem and it turns out that you need to change the IP
address of your default website to "(all Unassigned)", instead of
specifiying a specific IP address.
thuan wrote:
> Has anyone ran into this error yet while testing Report Manager?
> "The request failed with HTTP status 400: Bad Request."
> I can deploy and access reports directly, but I receive the above error when
> hitting the http://localhost/Reports URL (i.e. ReportManager)
> Also, I'm seeing DCOM errors in the NT event log whenever this happens. A
> search in the registry find CLSID references to network components (Network
> Connection Manager Class, Network Connection Manager Connection Enumerator
> Class, LAN Connection Manager Class, etc). Any ideas? Is there a security
> configuration that I'm missing?
> Here's an example entry:
> Event Type: Error
> Event Source: DCOM
> Event Category: None
> Event ID: 10016
> Date: 11/8/2005
> Time: 8:23:48 AM
> User: NT AUTHORITY\NETWORK SERVICE
> Computer: *SERVERNAME*
> Description:
> The application-specific permission settings do not grant Local Activation
> permission for the COM Server application with CLSID
> {BA126AD1-2166-11D1-B1D0-00805FC1270E}
> to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security
> permission can be modified using the Component Services administrative tool.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.

'' = 'ss' - are they equal?

Alex,
http://www.ureader.com/message/1343195.aspx has a conversation on this
subject you may find useful.
Most languages (especially English) have a fair number of homographs, which
are words spelled the same but with different pronunciations and meanings.
"Wind" can mean 'moving air' or 'tightening a spring', etc. I think that
you have probably run into this with your German words.
RLF
"Axel Dahmen" <KeenToKnow@.newsgroup.nospam> wrote in message
news:OP2PAHwQIHA.2396@.TK2MSFTNGP02.phx.gbl...
Hi,
I've set up an NVARCHAR table column having a UNIQUE constraint. This UNIQUE
constraint is supposed to keep double entries from being entered into that
column. So far so good...
In my new project I'm quite baffled about the fact that SQL Server 2000
seems to believe that '' and 'ss' are identical!
This assumption is only true for special cases. The German words "Mae" and
"Masse", for instance, have totally different meanings ("measures",
"mass"/"crowd").
How can I set up my table column definition (COLLATE perhaps?) in SQL Server
2000 to have it regard '' and 'ss' being distinct characters?
Your help is quite appreciated.
Best regards,
Axel Dahmen
Axel,
I imagine from the ANSI-SQL docuements that SQL is tracking with the ISO
standard on this. I see that the ISO collation standard was updated in
2007, but I am not willing to pay to find out what changed.
http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=44872
So, I don't know who to ask to get a good answer for you about what SQL is
doing. (Maybe Joe Celko has an update.)
In the meantime, if is worth the extra work for you, you can use this
workaround.
SELECT * FROM Composers
WHERE LastName = 'Strau'
AND LastName COLLATE Latin1_General_BIN = 'Strau'
The extra binary collation compare will ensure that you get 'Strau' and do
not get ' Strauss'.
RLF
"Axel Dahmen" <KeenToKnow@.newsgroup.nospam> wrote in message
news:%23EJWJu4QIHA.5400@.TK2MSFTNGP04.phx.gbl...
Great, Russel, thanks!
From the conversation you mentioned I've learned that according to DIN and
ANSI-SQL "" equals to "ss". But in fact this isn't true anymore since
German has been updated to new spelling rules a few years ago.
With the spelling reform we've got they changed the meaning of "". It has
now become a letter of its own and is no more a replacement for "ss". They
are even planning to introduce a new, "capital " letter.
With the old spelling rules words like "Mae" were equal to "Masse". But
nowadays this isn't true anymore.
Are there any plans to update ANSI-SQL and SQL-Server collation rules
according to current German rules?
TIA,
Axel Dahmen
"Russell Fields" <russellfields@.nomail.com> schrieb im Newsbeitrag
news:e6VOWBxQIHA.4180@.TK2MSFTNGP06.phx.gbl...
> Alex,
> http://www.ureader.com/message/1343195.aspx has a conversation on this
> subject you may find useful.
> Most languages (especially English) have a fair number of homographs,
> which
> are words spelled the same but with different pronunciations and meanings.
> "Wind" can mean 'moving air' or 'tightening a spring', etc. I think that
> you have probably run into this with your German words.
> RLF
>
> "Axel Dahmen" <KeenToKnow@.newsgroup.nospam> wrote in message
> news:OP2PAHwQIHA.2396@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I've set up an NVARCHAR table column having a UNIQUE constraint. This
> UNIQUE
> constraint is supposed to keep double entries from being entered into that
> column. So far so good...
> In my new project I'm quite baffled about the fact that SQL Server 2000
> seems to believe that '' and 'ss' are identical!
> This assumption is only true for special cases. The German words "Mae"
> and
> "Masse", for instance, have totally different meanings ("measures",
> "mass"/"crowd").
> How can I set up my table column definition (COLLATE perhaps?) in SQL
> Server
> 2000 to have it regard '' and 'ss' being distinct characters?
> Your help is quite appreciated.
> Best regards,
> Axel Dahmen
>
>

'' = 'ss' - are they equal?

Alex,
http://www.ureader.com/message/1343195.aspx has a conversation on this
subject you may find useful.
Most languages (especially English) have a fair number of homographs, which
are words spelled the same but with different pronunciations and meanings.
"Wind" can mean 'moving air' or 'tightening a spring', etc. I think that
you have probably run into this with your German words.
RLF
"Axel Dahmen" <KeenToKnow@.newsgroup.nospam> wrote in message
news:OP2PAHwQIHA.2396@.TK2MSFTNGP02.phx.gbl...
Hi,
I've set up an NVARCHAR table column having a UNIQUE constraint. This UNIQUE
constraint is supposed to keep double entries from being entered into that
column. So far so good...
In my new project I'm quite baffled about the fact that SQL Server 2000
seems to believe that '' and 'ss' are identical!
This assumption is only true for special cases. The German words "Mae" and
"Masse", for instance, have totally different meanings ("measures",
"mass"/"crowd").
How can I set up my table column definition (COLLATE perhaps?) in SQL Server
2000 to have it regard '' and 'ss' being distinct characters?
Your help is quite appreciated.
Best regards,
Axel Dahmen
Axel,
I imagine from the ANSI-SQL docuements that SQL is tracking with the ISO
standard on this. I see that the ISO collation standard was updated in
2007, but I am not willing to pay to find out what changed.
http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=44872
So, I don't know who to ask to get a good answer for you about what SQL is
doing. (Maybe Joe Celko has an update.)
In the meantime, if is worth the extra work for you, you can use this
workaround.
SELECT * FROM Composers
WHERE LastName = 'Strau'
AND LastName COLLATE Latin1_General_BIN = 'Strau'
The extra binary collation compare will ensure that you get 'Strau' and do
not get ' Strauss'.
RLF
"Axel Dahmen" <KeenToKnow@.newsgroup.nospam> wrote in message
news:%23EJWJu4QIHA.5400@.TK2MSFTNGP04.phx.gbl...
Great, Russel, thanks!
From the conversation you mentioned I've learned that according to DIN and
ANSI-SQL "" equals to "ss". But in fact this isn't true anymore since
German has been updated to new spelling rules a few years ago.
With the spelling reform we've got they changed the meaning of "". It has
now become a letter of its own and is no more a replacement for "ss". They
are even planning to introduce a new, "capital " letter.
With the old spelling rules words like "Mae" were equal to "Masse". But
nowadays this isn't true anymore.
Are there any plans to update ANSI-SQL and SQL-Server collation rules
according to current German rules?
TIA,
Axel Dahmen
"Russell Fields" <russellfields@.nomail.com> schrieb im Newsbeitrag
news:e6VOWBxQIHA.4180@.TK2MSFTNGP06.phx.gbl...
> Alex,
> http://www.ureader.com/message/1343195.aspx has a conversation on this
> subject you may find useful.
> Most languages (especially English) have a fair number of homographs,
> which
> are words spelled the same but with different pronunciations and meanings.
> "Wind" can mean 'moving air' or 'tightening a spring', etc. I think that
> you have probably run into this with your German words.
> RLF
>
> "Axel Dahmen" <KeenToKnow@.newsgroup.nospam> wrote in message
> news:OP2PAHwQIHA.2396@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I've set up an NVARCHAR table column having a UNIQUE constraint. This
> UNIQUE
> constraint is supposed to keep double entries from being entered into that
> column. So far so good...
> In my new project I'm quite baffled about the fact that SQL Server 2000
> seems to believe that '' and 'ss' are identical!
> This assumption is only true for special cases. The German words "Mae"
> and
> "Masse", for instance, have totally different meanings ("measures",
> "mass"/"crowd").
> How can I set up my table column definition (COLLATE perhaps?) in SQL
> Server
> 2000 to have it regard '' and 'ss' being distinct characters?
> Your help is quite appreciated.
> Best regards,
> Axel Dahmen
>
>