| 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
|
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
|