Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

"HTTP 400: Bad Request" - Reporting Services 2005 Expand / Collapse
Author
Message
Posted Tuesday, November 08, 2005 10:07 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, April 10, 2014 8:38 PM
Points: 37, Visits: 170

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.

Post #235765
Posted Wednesday, November 09, 2005 12:54 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, April 10, 2014 8:38 PM
Points: 37, Visits: 170

fyi, I found the problem, here's the resolution...

IP Address Mapping

Reporting Services requires that the default Web site IP address is mapped to (All Unassigned). To verify this setting, open the Default Web Site Properties dialog box in Internet Information Services. The IP address is specified on the Web Site tab.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8k82.asp

Post #236127
Posted Monday, November 21, 2005 4:36 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 08, 2009 4:54 PM
Points: 3, Visits: 5
Yes that's correct. It did solve my problem but anyway to solve that problem? We have multiple web sites on a box and cant do "All Unassigned" for the default web site.
Post #238697
Posted Monday, November 21, 2005 5:20 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, April 10, 2014 8:38 PM
Points: 37, Visits: 170

No, not yet.  We moved reporting services to its own website, and it still came up with the same error when not mapped to "All Unassigned". 

Some of the documents and forum posts I've been reading suggest it will be required to modify Reportmanager and ReportServices *.config files to set the correct URL.  The default website is satisfying our requirements for now, but we'll need to do more research.

Post #238710
Posted Monday, June 12, 2006 8:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 08, 2014 5:19 AM
Points: 3, Visits: 59

Came accross this problem and have solved it

In the RSWebApplication.config file in the ReportManager folder for your SQL 2005 Reporting Services instance.

If you 2005 instance is called SQL2005 you will  have the block of XML:

 <UI>
  <ReportServerUrl></ReportServerUrl>
  <ReportServerVirtualDirectory>ReportServer$SQL2005</ReportServerVirtualDirectory>
  <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
 </UI>

If you change this to:

 <UI>
  <ReportServerUrl>http://<Servername>/ReportServer$SQL2005</ReportServerUrl>
  <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
  <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
 </UI>

All worked for me.

Tim 

Post #286703
Posted Tuesday, July 18, 2006 12:38 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 22, 2013 3:51 PM
Points: 17, Visits: 36
Thanks Thuan! Your solution solved my problem!
Post #295275
Posted Thursday, July 27, 2006 9:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 19, 2008 1:27 PM
Points: 1, Visits: 2

There's a subtle issue that I didn't catch when reading Tim's post.  You can't specify both <ReportServerUrl> and <ReportServerVirtualDirectory>, so if you add a full URL for the <ReportServerUrl> value, you need to delete the <ReportServerVirtualDirectory> value.

Otherwise, this suggestion fixed my problem.  The strange thing is that it had been working for months until it failed today.  Go figure.

Melissa

Post #297818
Posted Wednesday, June 04, 2008 7:01 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 04, 2008 6:45 PM
Points: 1, Visits: 2
Many thanks I had the same problem with my reporting server and this fixed it.
Ayla:)
Post #511878
Posted Tuesday, July 14, 2009 3:52 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, January 22, 2014 5:08 AM
Points: 11, Visits: 172
Thanks Tim, I had the same problem and your solution fixed the issue.
Post #752547
Posted Wednesday, January 06, 2010 8:09 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 7:50 AM
Points: 404, Visits: 1,124
Tim,

I'm yet another person to benifit from your fix.

Thanks - work like a charm


_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)
Post #842833
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse