HTTP status 400: Bad Request
I just installed sql server 2005 on a windows 2003 server. I chose the option to install but do not configure. After restarting, I used the Reporting SErvices Configuration Manager and it all looks ok. When I browse to //localhost/reports I get a rs page with the message of: The request failed with HTTP status 400: Bad Request.One slightly unusual thing is SQL Server 2005 was installed as a named instance ("(local)\SQL2K5") - the server's default instance is a sql 2000 installation, which had RS installed and running. Before configuring RS for 2k5, I deleted the VDs for Reports and ReportServer from IIS, so that I could recreate them to use 2K5.The new ReportServer VD appears to work (although no reports are installed to test).Thanks for any help getting this issue resolved!
December 12th, 2005 8:11pm
I have a bunch of these in Application Log... I have a feeling it's related.. I don't know what it means thoughThe 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. Anyone???
Free Windows Admin Tool Kit Click here and download it now
December 12th, 2005 10:25pm
I'm not sure the applog error that you're catching is related, so let's try to fix it and then see if the original problem goes away (I suspect it won't): 1. Click Start | Run and run dcomcnfg.exe 2. In MMC, open Component Services | My Computer 3. Right-click My Computer, choose Properties, select the COM Security tab. Click on the edit default button in Launch permissions options area 4. Add network service and give it appropriate perms (Local Launch and Local Activation permissions) If that doesn't do the trick: 1. Start DCOMCNFG 2. Under Component Services -> My Computer -> Dcom Config -> Netman click Properties, then Security tab 3. In Launch and Activation Permissions box click Edit. 4. Add Network Service with Local Launch and Local Activation permissions Good luck!
December 13th, 2005 2:54am
Nope... you were right - neither worked.I have since created 2 new VDs - Reports2K5 and ReportServer2k5, which correspond to my instance of SQL SErver 2005. The REportServer2K5 appears to be working OK... Reports2K5 (manager) still gives me the 400 error.Would this error be logged anywhere?Thanks for your help.
Free Windows Admin Tool Kit Click here and download it now
December 13th, 2005 10:58pm
The site (Default web site) was using a specific IP address.. I changed it to All Unassigned and it works!
December 13th, 2005 11:17pm
Is there a way to configure SQL 2005 Reporting Services using an IIS Website with a specific IP?
December 18th, 2005 9:25pm
I'm getting the same event error:
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.
I went into Component Services and Netman has local launch permissions and can find no reference for "Network Connection Manager Class" (the name the ID translates to based upon registry lookup). What in Component Services should I be looking for and where? This is a brand new installation of 2003 Server Professional w/ Exchange 2003 and all the latest service packs/patches. Thanks,
John
Free Windows Admin Tool Kit Click here and download it now
January 4th, 2006 5:10pm
Had very similar on 4 servers, all using unassigned , but they all had host headers specified. Short summary below to explain.
Each server had three web sites all bound to unassigned ip address, using host headers and diffrent ssl ports to separate ou the traffic.
Report server had previously been working ok until the final site config when the host headers were implemented.
As one site could act as a default then the problem was resolved by adding an additionalbinding for port 80 with no header specified.
All boxes running fine now.
The origonal posting pointed me in the right direction and as I was also implmenting http endpoints in SQL , I could have spent awhile on red herings. Much thanks.
January 27th, 2006 4:52pm
I believe this errors can be fixed by the following 899965
http://support.microsoft.com/?kbid=899965
Free Windows Admin Tool Kit Click here and download it now
February 8th, 2006 12:42am
had a similar problem and found out the following:
If you want to run Reporting Services under a different port than normal, you have to change these two config files:rsreportserver.configandRSWebApplication.configEnter the full path (like http://servername:port/ReportServer) to <ReportServerUrl> (delete <ReportServerVirtualDirectory> then!) or resp. <UrlRoot>The result is then <Configuration> <UI> <ReportServerUrl>http://mbs05:8088/reportserver</ReportServerUrl> <ReportServerVirtualDirectory></ReportServerVirtualDirectory> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel> </UI>.....and<Configuration>... <Service>.... <MaxQueueThreads>0</MaxQueueThreads> <UrlRoot>http://mbs05:8088/reportserver</UrlRoot> <UnattendedExecutionAccount>...Hope this helps,MartinPS: see also http://msdn2.microsoft.com/en-us/library/ms159261(SQL.90).aspx
March 23rd, 2006 3:43pm
Just a blank host header for a site that has an assigned IP. Work on three different boxes for me.
Free Windows Admin Tool Kit Click here and download it now
April 13th, 2006 10:47pm
Same for me. I moved Reporting Services to it's own website (because sharepoint installed it's own ISAPI filter on the default website that was totally screwing up RS), and set a host header for the new site. Every time I turned off the default website, RS would break, even though it should have nothing to do with it.I switched the host headers around (so the default website has host headers, and the RS website doesn't) now it works perfectly.
July 14th, 2006 10:36am
Folks,
I'm trying to resolve the same error but having a bit of trouble following through the instructions in the KB.
If one of you could please set me right it would be much appreciated.
Firstly, the error I'm getting in the event log is as follows:
"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."
So I go to the regedit and look it up.I search for BA126AD1-2166-11D1-B1D0-00805FC1270EAnd Regedit duly comes up with:
HKEY_CLASSES_ROOT\CLSID\{BA126AD1-2166-11D1-B1D0-00805FC1270E}
Which identifies this as the "Network Connection Manager Class"
Allright..now the KB article then tells me to :
4.
Click Start, click Run, type dcomcnfg in the Open box, and then click OK. If a Windows Security Alert message prompts you to keep blocking the Microsoft Management Console program, click to unblock the program.
5.
In Component Services, double-click Component Services, double-click Computers, double-click My Computer, and then click DCOM Config.
6.
In the details pane, locate the program by using the friendly name.If the AppGUID identifier is listed instead of the friendly name, locate the program by using this identifier.
And this is where I'm stuck.. cos there is nothing there that corresponds to a Network Connection Manager Class or to the CLSID... (is that what they mean in the doc when they refere to AppGUID ?)
So, I can't continue on with the fix.. because I can't find the right app to fix the launch and activation permissions for....
I'd really appreciate a bit of help on this one...
Thanks
PJ
Free Windows Admin Tool Kit Click here and download it now
January 18th, 2007 1:26pm
Another question on this...just to be sure I'm chasing the right tail....
When I point a browser at the site http://localhost/Reportserver$DeptServer05I get the following message...
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
Object reference not set to an instance of an object.
Which logfile is the message referring to ? Is it the one at C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles ???
Cos the errors in that file refer me to another logfile....
w3wp!library!7!01/18/2007-08:23:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetWebConfigAuthenticationAttribute(String attrName) at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetAuthenticationType() at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.get_UsingWindowsAuth() at Microsoft.ReportingServices.WebServer.Global.EnableAntiDos() at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos() at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e) --- End of inner exception stack trace ---
So which logfile is THIS one referring to?
I've gone into the event log on the system and all I can find are the bunch of DCOM messages(see previous post)which I'm presuming are related...
Thanks
PJ
January 18th, 2007 2:01pm
I'm also getting this error in the SQLDmpr0304.log file...
Would there be anything in the " Evaluation copy: 0 days left" bit...???
Tahnks
PJ
w3wp!resourceutilities!1!18/01/2007-10:46:38:: i INFO: Reporting Services starting SKU: Enterprisew3wp!resourceutilities!1!18/01/2007-10:46:38:: i INFO: Evaluation copy: 0 days leftw3wp!runningjobs!1!18/01/2007-10:46:38:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 secondsw3wp!runningjobs!1!18/01/2007-10:46:38:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 secondsw3wp!runningjobs!1!18/01/2007-10:46:38:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 secondsw3wp!runningjobs!1!18/01/2007-10:46:38:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 secondsw3wp!library!1!01/18/2007-10:46:38:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetWebConfigAuthenticationAttribute(String attrName) at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetAuthenticationType() at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.get_UsingWindowsAuth() at Microsoft.ReportingServices.WebServer.Global.EnableAntiDos() at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos() at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e) --- End of inner exception stack trace ---
Free Windows Admin Tool Kit Click here and download it now
January 18th, 2007 5:25pm
I've run into the same problem as described by the original post. I've followed the first part of your directions Chris and am wondering about how the permissions are applied. If I grant the network service local launch and local activation permissions at the "My Computer" level, do those permissions flow down to everything under "My Computer"? I wondered if I should have first applied them at the netman com object level instead of the "My Computer" level.
Thanks,
Dave
January 25th, 2007 7:35pm
Yeah, tell me about it! I've got the same problem and came to the same conclusion. After reading some here I followed the first part of the directions that Russell Christopher posted. I'm now in a wait and see mode. I'll get back to ya if I see that it fixed my problem.
Free Windows Admin Tool Kit Click here and download it now
January 25th, 2007 7:44pm
Looks like I have this fixed.
Did it by allowing the ASPNET and IUSR user have access to the physical directories on the disk.
Of course that was after following the previous excellent instructions on allowing netman have network access too...
Thanks folks,
PJ
January 25th, 2007 7:48pm
Yep, the directions in this article fixed the DCOM error refering to the netman com object. The article says it only applies to Windows XP, but I applied this fix to a Windows 2003 64 bit server. Thanks Milo145.
Free Windows Admin Tool Kit Click here and download it now
January 31st, 2007 4:56pm
The application you are looking for is netman. When you look at the properties for netman, you will see the matching APPID
March 23rd, 2007 4:25pm
I added 127.0.0.1 to the IIS web site after getting this error and it started working again... Somethingmust beusing localhost. Just my 2cents.
Free Windows Admin Tool Kit Click here and download it now
June 7th, 2007 11:14pm
Very helpful and simple, thanks!
August 13th, 2007 11:23pm
Yes , this working now. I am able to open Reporting Services. Probably I will have anather problem since I use this server to host multiply web sites ( diferent IP addresses).
Any idea what to do???
Free Windows Admin Tool Kit Click here and download it now
November 13th, 2007 8:03pm
Thanks!
October 22nd, 2008 4:47pm
I changed it to All Unassigned too and it works! Thanks ALFKI!
Free Windows Admin Tool Kit Click here and download it now
June 18th, 2009 10:19pm
For me, the issue boiled down to adapter binding order. We have two adapters (backup VLAN and production network). For some reason (known only to the Windows Admins), the Backup VLAN was first in the binding order. I discovered this when I pinged using the host name on the server itself (and the response came back from the backup VLAN IP).Changed the binding order and that was that.Regards,hmscott4
September 23rd, 2009 10:09pm
To avoid a HTTP 400 Bad Request Invalid Hostname error when adding an SSL certificate to a stand-alone (no IIS) Reporting Services 2008 instance running on Windows Server 2003, I had to:
download the
Windows Server 2003 Service Pack 2 32-bit Support Tools to get httpcfg run the following command to manually map all assigned IPs to the SSL url (copying the ACL from the auto-created one): httpcfg set urlacl /u "https://+:443/ReportServer/" /a "D:(A;;GX;;;NS)"
Windows Vista / 7 / 2008 and later have switched to using netsh with a different syntax instead of httpcfg.
Free Windows Admin Tool Kit Click here and download it now
February 26th, 2011 8:08am