Display Posts for:
Server Error on Windows Azure
Invert
miguel angel roda 03/16/2012 17:03
Server Error on Windows Azure

I'm testing the report viewer control of SilverLigth in local machine and can see reports, but not when trying to display a report on windows azure,

The exception is:

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>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 11.0.1722.11" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="127" />
<meta name="CountryLocaleID" content="1033" />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}

</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>The Authentication Extension threw an unexpected exception or returned a value that is not valid: identity==null. (rsAuthenticationExtensionError) <a href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsAuthenticationExtensionError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=11.0.1722.11" target="_blank">Get Online Help</a></li><ul>
<li>Tracing ID is: 0bdd3172-094c-4736-a1d5-7cd8b7e729e3.</li>
</ul>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--.

My web.config is:

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
<configSections>
<sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
<section name="Portal.UI.Application.Web.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
</sectionGroup>
<section name="PerpetuumSoftServices" type="PerpetuumSoft.ReportingServices.Viewer.Server.ServicesConfigurationSection, PerpetuumSoft.ReportingServices.Viewer.Server" allowLocation="true" allowDefinition="Everywhere" />
</configSections>
<system.web>
<compilation debug="true" targetFramework="4.0" />
<globalization uiCulture="es-ES" culture="es-ES" />
<machineKey decryption="AES" decryptionKey="F7FA540B4DFD82E5BB196B95D15FF81FF8DB68DCCADCA1FEC1E23C56135826E4" validation="SHA1" validationKey="F8DB68DCCADCA1FEC1E23C56135826E4E59018839DE62168764FF0DCE537184F0535D5D9AD66DEDCF8DB68DCCADCA1FEC1E23C56135826E4E590188397DC1ABF" />
</system.web>
<PerpetuumSoftServices>
<LogMode value="On" />
<Service Type="Portal.UI.Application.Web.MReportService, Portal.UI.Application.Web">
<MsReportingServer Url="https://s80alzd0-d.reporting.windows.net/reportserver/ReportExecution2005.asmx">
<Credentials Domain="" UserName="" Password="" />
</MsReportingServer>
</Service>
</PerpetuumSoftServices>
<applicationSettings>
<Portal.UI.Application.Web.Properties.Settings>
<setting name="TokenQueryStringAllowed" serializeAs="String">
<value>True</value>
</setting>
</Portal.UI.Application.Web.Properties.Settings>
</applicationSettings>
<system.diagnostics>
<trace>
<listeners>
<add type="Microsoft.WindowsAzure.Diagnostics.DiagnosticMonitorTraceListener, Microsoft.WindowsAzure.Diagnostics, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" name="AzureDiagnostics">
<filter type="" />
</add>
</listeners>
</trace>
</system.diagnostics>
<system.webServer>
<directoryBrowse enabled="true" />
</system.webServer>
<!--perpetum service-->
<system.serviceModel>
<behaviors>
<serviceBehaviors>
<behavior name="ReportServiceBehavior">
<serviceMetadata httpsGetEnabled="true" />
<serviceDebug includeExceptionDetailInFaults="true" />
</behavior>
</serviceBehaviors>
<endpointBehaviors>
<behavior name="webBehavior">
<webHttp />
</behavior>
</endpointBehaviors>
</behaviors>
<serviceHostingEnvironment aspNetCompatibilityEnabled="true" multipleSiteBindingsEnabled="true" />
<services>
<service behaviorConfiguration="ReportServiceBehavior" name="Portal.UI.Application.Web.MReportService">
<endpoint address="" binding="basicHttpBinding" bindingConfiguration="basicHttpBindingConf" contract="PerpetuumSoft.ReportingServices.Viewer.Server.IReportService">
<identity>
<dns value="localhost" />
</identity>
</endpoint>
<endpoint address="mex" binding="mexHttpsBinding" contract="IMetadataExchange" />
<endpoint address="rest" binding="webHttpBinding" contract="PerpetuumSoft.ReportingServices.Viewer.Server.IReportServiceResources" behaviorConfiguration="webBehavior" bindingConfiguration="webHttpBindingConf" />
</service>
</services>
<bindings>
<webHttpBinding>
<binding name="webHttpBindingConf">
<security mode="Transport" />
</binding>
</webHttpBinding>
<basicHttpBinding>
<binding name="basicHttpBindingConf">
<security mode="Transport" />
</binding>
</basicHttpBinding>
</bindings>
</system.serviceModel>
</configuration>

I really would like this to work so I can go ahead and approve the purchase of the product.
Dmitry Plutalov 03/20/2012 05:20
Server Error on Windows Azure

Hello,

Did you try to specify your SQL server credentials in the Credentials section of web.config? It seems that there are some authorization problems.

Also, please, note that Silverlight viewer for Reporting Services requires rendering extension to be set on the Reporting Services, but, unfortunately Windows Azure Sql Server Reporting Services does not support this feature. The only way to do that is to use Windows Azure VM Role feature.

You may find more information here:
http://msdn.microsoft.com/en-us/library/windowsazure/gg433107.aspx

Best Regards,
Dmitry Plutalov
Perpetuum Software Team
  
Microsoft Certified Partner

 USA

Phone: +1 (813) 514-0531

sales-usa@perpetuumsoft.com

 América Latina

Phone: +55 (11) 4618-0368

vendas@perpetuumsoft.com

 Europe

Phone: +49 (0) 6202 5740 111

sales-europe@perpetuumsoft.com

 Russia

Phone: +7 (385) 256-72-95

sales@perpetuumsoft.com


As a Gold Certified Partner in the Microsoft Partner program, Perpetuum Software has been providing a wide range of Microsoft Visual Studio components for over 8 years. Perpetuum Software product lines include WinForms, WPF, ASP.NET, HTML5, Silverlight, Windoes 8 and Mobile components, and tools for SQL Server Reporting Services. Among them are .NET reporting tool, OLAP component, and such data visualization libraries as gauge and charting products.