Hi, I've decided to install SSRS (2005) on my windows XP machine. I'm not very familiar with IIS (i'm currently using version 5.1) and I think between IIS and SSRS, i've managed to break something.
I've been looking at various articles to try and get some clarity on my predicament. However, i'm not getting any joy with them.s
I have located the logfiles (which I can provide). Unfortunately, I have no idea how to intepret the information contained therein.
Can anyone help?
Many thanks in advance
ClintPlease provide more information. First make sure every tab in the configuration tool is green. Then try to access your report server virtual directory. If there is an error on the web page please copy it here. Also copy the corresponding error in the log files.|||
Hi James, thank you for taking the time to answer me. I will endeavour to provide the information that you requested.
1. The configuration window - This is what i'm getting when I view it.
Picture held on my web site
2. When I try and browse to my Reporting Server (using I.E. 7) with the name http://<servername>/reports this is what I get.
Server Error in '/Reports' Application.
The configuration file contains an element that is not valid. The ReportServerUrl element is not a configuration file element.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Exception: The configuration file contains an element that is not valid. The ReportServerUrl element is not a configuration file element.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. |
Stack Trace: [Exception: The configuration file contains an element that is not valid. The ReportServerUrl element is not a configuration file element.] Microsoft.ReportingServices.Diagnostics.RSConfiguration.ThrowInvalidFormat(String element) +41 Microsoft.ReportingServices.Diagnostics.UIConfiguration.ParseXML(XmlNode node, RSConfiguration configObject) +1135 Microsoft.ReportingServices.Diagnostics.RSConfiguration.ParseDocument() +972 Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +32 [ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information.] Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +166 Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName) +62 Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location) +296 Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation) +134 Microsoft.ReportingServices.UI.Global.get_ConfigurationManager() +84 Microsoft.ReportingServices.UI.GlobalApp.Application_Start(Object sender, EventArgs e) +32 |
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
3. The error logs are very long so if you look at the bottom of the link above, you'll see links to the files. I'm sorry about the crude mechanism to provide the information to you. But I hope you can see access them.
Many thanks
Clint
|||
Can you open your RSWebApplication.config file(%ProgramFiles%\Microsoft SQL Server\MSSQL.x\Reporting Services\ReportManager\RSWebApplication.config) and check the entries for ReportServerUrl and ReportServerVirtualDirectory. You have to specify ONLY one of them and not both.
For example,
<Configuration>
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
Thanks,
Sharmila
|||
Hi Sharmila, thanks for enquiring.
The contents of the configuration file is listed below:
The <servername> has replaced the name of my server.
Many thanks
Clint
-
<Configuration>
<UI>
<ReportServerUrl>http:/<servername>/reportserver</ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
<Extensions>
<DeliveryUI>
<Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl,ReportingServicesEmailDeliveryProvider">
<DefaultDeliveryExtension>True</DefaultDeliveryExtension>
<Configuration>
<RSEmailDPConfiguration>
<DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIControl,ReportingServicesFileShareDeliveryProvider"/>
</DeliveryUI>
</Extensions>
<Add Key="MaxActiveReqForOneUser" Value="20"/>
<Add Key="DisplayErrorLink" Value="true"/>
</Configuration>
|||
As seen in the config file, you have specified both ReportServerUrl and ReportServerVirtualDirectory. You can specify ONLY one.
<UI>
<ReportServerUrl>http:/<servername>/reportserver</ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
Try something like this,
<UI>
<ReportServerUrl>http:/<servername>/reportserver</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
Hope this helps,
Sharmila
|||
Hi Sharmila, out of interest does specifying both make a difference? You clearly seem to imply that it does, I was just curious to know.
I'm going to try it now.
Regards
Clint
|||
I've just tried it with /reports and got this.
|
| Error |
|
|
|
|
|
| |
|
| The report server is not responding. Verify that the report server is running and can be accessed from this computer. |
|
| Home |
I also tried browsing to the /reportserver and got this.
--
Reporting Services Error
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
For more information about this error navigate to the report server on the local server machine, or enable remote errors|||
Can we check a few things?
1. Is RS service running? Is yes, can we restart and also retart IIS.
2. Open the config tool and see if all sections are configured properly as before(in the screenshot you provided).
3. Also, look in the log files to get more info on the internal error.
Thanks,
Sharmila
|||
Hi Sharmila,
I have tried to answer your questions below:
1. I've restarted IIS
2. The configuration tool reports the service states in exactly the same way as my screen shot.
3. The report logs from 19:30 (GMT) are listed below the screenshot. Do you want me to provide the latest logs (22:30)?
Thanks
Clint
|||
Yes, please provide the latest logs.
Thanks,
Sharmila
|||
As an FYI..., there is a similar post that addresses the same issue. - http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=251336&SiteID=1
I just noticed that in the RSWebApplication.config, for ReportServerUrl, the Url is missing a "/" for http://. I'm assuming that it is just a typo. Can we just stop the RS service and start it again and also reset IIS.
<UI>
<ReportServerUrl>http:/<servername>/reportserver</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
Thanks,
Sharmila
|||
Hi. I've updated the logs here.
Thanks
Clint
|||
Hi. I've restarted the RS services and IIS and yes it was a typo.
Thank you
Clint
|||Do you have <xmlns=..."> in your web.config (both report server and report manager dir), rsreportserver.config or rswebapplication.config files? If so remove the line.
