Ok people,
I need some help trying to resolve one of our issues if you please....
If we go in to SCE 2007 that's installed as part of EBS 2008, then we get
Loading Reporting Hierarchy failed
The request failed with HTTP status 404: Not Found
Here's the stack trace
Date: 26/08/2009 18:23:06
Application: System Center Essentials
Application Version: 6.0.1885.0
Severity: Error
Message: Loading reporting hierarchy failed.
System.Net.WebException: The request failed with HTTP status 404: Not Found.
at System.Web.Services.Protoc
at System.Web.Services.Protoc
at Microsoft.EnterpriseManage
at Microsoft.EnterpriseManage
at Microsoft.EnterpriseManage
at Microsoft.EnterpriseManage
at Microsoft.EnterpriseManage
It's got to be something down to SRS on SQL Express that gets installed at the same time......
I cannot browse to http://localhost/reports or http://localhost/reportser
HTTP Error 500.19 - Internal Server Error
The requested page cannot be accessed because the related configuration data for the page is invalid. Detailed Error Information
Module DynamicCompressionModule
Notification SendResponse
Handler StaticFile
Error Code 0x8007007e
Requested URL http://vm-ebs-dc:80/report
Physical Path c:\Program Files (x86)\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportManager
Logon Method Not yet determined
Logon User Not yet determined
Most likely causes:
"The worker process is unable to read the applicationhost.config or web.config file.
"There is malformed XML in the applicationhost.config or web.config file.
"The server cannot access the applicationhost.config or web.config file because of incorrect NTFS permissions.
Things you can try:
"Look in the event logs for information about why the configuration files are not readable.
"Make sure the user identity specified for the application pool, or the authenticated user, has the required permissions to access the web.config file.
Links and More InformationThis error occurs when there is a problem reading the configuration file for the Web server or Web application. In some cases, the event logs may contain more information about what caused this error.
View more information »
Any ideas please ?
Cheers
Si
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Interesting. While I was checking for the SCE re-install steps, I found the following comment on the EBS blog. Looks like it might be your fix. It's a known problem and a hotfix is available. Hope this helps...
http://blogs.technet.com/e
Dan.
Hi Si,
Sorry I didn't get back to you. Haven't had time to be on here for a couple weeks now. Anyways, to bad, I thought for sure the fix would resolve your problem. It really seems to me that the problem is a misconfigured web site or a permissions issue with IIS. I'm not up to speed on IIS 7 so I'm not sure what to look for.
Try this, though... Open IIS Manager, expand the Default Web Site and you should see the Web directories available. Two of them are for SCE Reports. On my server they are Reports$SCE and ReportServer$SCE. If you right click, select Manage Application and then select browse, it should show you the SQL Server Reporting Services home page. Locate the folder for "Microsoft.SystemCenter.Es
My point to all of this is that if you can't get into the web site folders then you have a permissions problem or a configuration problem with the web site. If that's the case, you may want to check with some SQL / IIS experts on what to look for in the configuration. I've attached a copy of my web.config for the Reports$SCE site. It may give you some clues.
Si,
Another possiblility comes to mind. By default SCE uses port 80 for the SQL report services. Apparently, if you install Sharepoint services, it takes over port 80 and changes SCE reporting services to port 8080. Go to the SCE console and select the administration tab. Select "Settings" and locate Reporting in the view pane. Double click and check the port settings. Confirm that they match IIS configuration for reporting services.
Dan.
Dan
Herein seems to lie the problem.....
Here's the error, I'll have a further look, but if you find anything let me know
Cheers
Si
error
Si,
I think I found what you need. Located within the program files folder on all of the EBS servers is the Windows Essential Business Server folder that contains configuration files and binaries for the wizards used in EBS. Included in this structure are the installation files for a number of the components used including SQL server express, Exchange, SCE and so on. I would try running the following MSI file to see if it re-installs the SQL report server components: C:\Program Files\Windows Essential Business Server\Bin\SCE\Setup\i386\
If that fails, I'd try running the SCE setup again which is here: C:\Program Files\Windows Essential Business Server\Bin\SCE\SetupSCE.ex
Good Luck!!
You can't locate the SCE install program? Is it not in the C:\Program Files\Windows Essential Business Server\Bin\SCE\ folder? It should be. If not, then you may need to re-install the EBS binaries. Here's a posting from the EBS Team Blog that describes the process of repairing the EBS binaries on the three servers. It looks like a process that you need to follow carefully or you could have more problems.
http://blogs.technet.com/e
Not sure if you saw this link but I'll throw it in as well... "How to install the SCE Management Server"
It seems to be aimed more at a full product install on a standard Windows 2008 server, not EBS.
http://technet.microsoft.c
OK boys and girls,
I finally ended up having to reinstall the server.....Dan I see a post from you on t'internet about doing this.....
when I reinstalled the Management Server, EBS was totally groovy and redeployed itself with all of the settings that it had previously
It basically realised it was part of the domain and was very very clever
Note to everyone - although you can, NEVER NEVER NEVER remove System Center Essentials from EBS....you have to totally reinstall the server
Cheers
Si
Business Accounts
Answer for Membership
by: DNadon57Posted on 2009-08-26 at 23:43:38ID: 25195164
My suspicion is the problem may be IIS related. For instance, on my EBS management server, the URL for the SQL report service is http://localhost/Reports$S