Wednesday, March 7, 2012

Reporting Services error

Hi,

I am trying to implement a report using reprorting services and have just finished deploying it. I am using the June SQL 2005 CTP.

Books online then says to select Debug and Start after setting the TargetServerUrl. However, I get the error message below. Any help would be appreciated.

Regards,

Ned
TITLE: Microsoft Report Designer

A connection could not be made to the report server http://localhost/reportserver.


ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>Configuration Error</title>
<style>
body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;}
p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}
b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}
H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
pre {font-family:"Lucida Console";font-size: .9em}
.marker {font-weight: bold; color: black;text-decoration: none;}
.version {color: gray;}
.error {margin-bottom: 10px;}
.expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }
</style>
</head>

<body bgcolor="white">

<span><H1>Server Error in '/ReportServer' Application.<hr width=100% size=1 color=silver></H1>

<h2> <i>Configuration Error</i> </h2></span>

<font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">

<b> Description: </b>An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
<br><br>

<b> Parser Error Message: </b>The format of the file 'ReportingServicesWebServer' is invalid.<br><br>

<b>Source Error:</b> <br><br>

<table width=100% bgcolor="#ffffcc">
<tr>
<td>
<code><pre>

Line 27: <assemblies>
Line 28: <clear />
<font color=red>Line 29: <add assembly="ReportingServicesWebServer" />
</font>Line 30: </assemblies>
Line 31: </compilation></pre></code>

</td>
</tr>
</table>

<br>

<b> Source File: </b> C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config<b> Line: </b> 29
<br><br>

<b>Assembly Load Trace:</b> The following information can be helpful to determine why the assembly 'ReportingServicesWebServer' could not be loaded.<br><br>

<table width=100% bgcolor="#ffffcc">
<tr>
<td>
<code><pre>

=== Pre-bind state information ===
LOG: DisplayName = ReportingServicesWebServer
(Partial)
LOG: Appbase = file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer
LOG: Initial PrivatePath = bin
Calling assembly : (Unknown).
===

LOG: Policy not being applied to reference at this time (private, custom, partial, or location-based assembly bind).
LOG: Post-policy reference: ReportingServicesWebServer
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/reportserver/a118fdc2/4881a74/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/reportserver/a118fdc2/4881a74/ReportingServicesWebServer/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer/bin/ReportingServicesWebServer.DLL.
</pre></code>

</td>
</tr>
</table>

<br>

<hr width=100% size=1 color=silver>

<b>Version Information:</b> Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300

</font>

</body>
</html>
<!--
[BadImageFormatException]: The format of the file 'ReportingServicesWebServer' is invalid.
at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Boolean isStringized, Evidence assemblySecurity, Boolean throwOnFileNotFound, Assembly locationHint, StackCrawlMark& stackMark)
at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Boolean stringized, Evidence assemblySecurity, StackCrawlMark& stackMark)
at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark)
at System.Reflection.Assembly.Load(String assemblyString)
at System.Web.UI.CompilationConfiguration.LoadAssemblies(Hashtable original)
[ConfigurationException]: The format of the file 'ReportingServicesWebServer' is invalid. (C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config line 29)
at System.Web.UI.CompilationConfiguration.LoadAssemblies(Hashtable original)
at System.Web.UI.TemplateParser.AppendConfigAssemblies()
at System.Web.UI.TemplateParser.PrepareParse()
at System.Web.UI.TemplateParser.Parse()
at System.Web.UI.TemplateParser.GetParserCacheItemThroughCompilation()
at System.Web.UI.TemplateParser.GetParserCacheItemInternal(Boolean fCreateIfNotFound)
at System.Web.UI.TemplateParser.GetParserCacheItemWithNewConfigPath()
at System.Web.UI.TemplateParser.GetParserCacheItem()
at System.Web.UI.ApplicationFileParser.GetCompiledApplicationType(String inputFile, HttpContext context, ApplicationFileParser& parser)
at System.Web.HttpApplicationFactory.CompileApplication(HttpContext context)
at System.Web.HttpApplicationFactory.Init(HttpContext context)
at System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context)
at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
-->
--. (Microsoft.ReportingServices.Designer)


BUTTONS:

OK

From the error message it seems like the report server virtual roots of your CTP June installation are explicitly configured to use ASP.NET 1.1. This won't work. CTP June requires that the virtual roots are configured to use ASP.NET 2.0.

-- Robert|||Hi Robert,

Is there an easy way to reconfigure this?

Regards,

Ned|||SQL Server 2005 Setup should configure virtual roots automatically to use ASP.NET 2.0 during installation.

The IIS administration tool (e.g. part of compmgmt.msc) also may have an option to set the ASP.NET version of virtual roots explicitly.

Furthermore, you can use the aspnet_regiis command line tool:
* aspnet_regiis /lk ... to check the current virtual root ASP.NET mappings
* aspnet_regiis /s path ... to change the version mappings

You could also install e.g. CTP September and use the new RS configuration tool to recreate the virtual roots and apply correct configuration settings.

-- Robert|||

Thanks Robert,

I'll give this a try.

|||

i dont know if you resolve the problem or no but oi think i resolve it

the problem is the configurations of the current version of .net frame work installed on the system is not compatible with reporting services to reconfigurate it u can access to the directory:
"c:\Windows\Microsoft.NET\Framework\v2.0.50727"

there you will find several exe files one of them can reconfigure trully your configurations i tried them all (arrange files by type will be helpful) and after thats i deployed my report on the directory(http://localhost/ReportServer)

hope that will be helpful

No comments:

Post a Comment