SSRS2008 R2 Custom Authentication
Hi,
I tried the custom authentication sample from codeplex. It worked fine. Now I am trying to implement the custom authentication as per our company standards. So I modified the following
ReportServer:Web.config.,RSreportserver.config,reportingservice.exe.config,rssrvpolicy.config
ReportManager:Web.config,rsmgrpolicy
I am able to see the login page. Once I enter my credentials I get the following error.
[WebException: The request failed with HTTP status 404: Not Found.]
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) +413022
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) +300
ReportService2010.ReportingService2010.LogonUser(String userName, String password, String authority) +185
SSRSExtensions.Security.UILogon.Page_Load(Object sender, EventArgs e) +449
System.Web.UI.Control.OnLoad(EventArgs e) +132
System.Web.UI.Control.LoadRecursive() +66
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2428
When i try to browse the Reportingservice2010.asmx from a browser I get the following error.
A string literal was expected, but no opening quote character was found. Error
processing resource http://xxxx:5051
Server Error in /ReportServer_MSSQLSERVER_SSRS Application
July 17th, 2012 6:19am
Adding more information from the log file.
appdomainmanager!DefaultDomain!e30!07/17/2012-05:52:56:: i INFO: Appdomain:4 ReportManager_MSSQLSERVER_SSRS_0-2-129869959762315170 started.
appdomainmanager!ReportManager_0-2!e30!07/17/2012-05:52:57:: i INFO: RS authentication mode is 16; effective ASP.NET authentication mode is Forms. vdir=/Reports_MSSQLSERVER_SSRS.
appdomainmanager!DefaultDomain!e30!07/17/2012-05:52:57:: i INFO: Appdomain:4 ReportManager_MSSQLSERVER_SSRS_0-2-129869959762315170 initialized (#1).
appdomainmanager!ReportManager_0-2!e30!07/17/2012-05:52:59:: e ERROR: AppDomain creation is not supported in this version of Reporting Services. (AppDomain Name=WebProxyScript)
library!ReportManager_0-2!e30!07/17/2012-05:52:59:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.NotYetSupportedException: , Microsoft.ReportingServices.Diagnostics.Utilities.NotYetSupportedException:
The requested functionality is currently not supported.;
ui!ReportManager_0-2!959c!07/17/2012-05:53:07:: Unhandled exception: System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.Net.WebException: The request failed with HTTP status 404: Not Found.
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at ReportService2010.ReportingService2010.LogonUser(String userName, String password, String authority)
at SSRSExtensions.Security.UILogon.Page_Load(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
--- End of inner exception stack trace ---
Any hints /pointers will be very useful.
Thanks in advance.vivek
Free Windows Admin Tool Kit Click here and download it now
July 17th, 2012 6:58am
Hello vivek,
Thank you to post your question on TechNet forum.
From the error message, I doubted that you does not configure the custom authentication properly. We have a good instruction to guide you to configure the Reporting service on Custom authentication.
http://msftrsprodsamples.codeplex.com/wikipage?title=SS2008R2!Security%20Extension%20Sample
Please follow it to check it by yourself.
Meanwhile, from the error message, I doubted that the configuration was not set properly. For example, the <UI> tag in the rsreportserver.config is not set properly. It should be:
<UI>
<CustomAuthenticationUI>
<loginUrl>/Pages/UILogon.aspx</loginUrl>
<UseSSL>True</UseSSL>
</CustomAuthenticationUI>
<ReportServerUrl>http://<server>/ReportServer</ReportServerUrl>
</UI>
If you are running the sample security extension in a development environment that does not have a Secure Sockets Layer (SSL) certificate installed, you must change the value of the <UseSSL> element to
False in the previous configuration entry.
If you still have the problem, please post out the two web.config in Report Manager and Report Server and rsreportserver.config file, so that we can check it for further troubleshooting.
Regards,
Edward
TechNet Subscriber Support
If you are
TechNet Subscription user and have any feedback on our support quality, please send your feedback
here.Edward Zhu
TechNet Community Support
July 18th, 2012 3:30am
Hello vivek,
Thank you to post your question on TechNet forum.
From the error message, I doubted that you does not configure the custom authentication properly. We have a good instruction to guide you to configure the Reporting service on Custom authentication.
http://msftrsprodsamples.codeplex.com/wikipage?title=SS2008R2!Security%20Extension%20Sample
Please follow it to check it by yourself.
Meanwhile, from the error message, I doubted that the configuration was not set properly. For example, the <UI> tag in the rsreportserver.config is not set properly. It should be:
<UI>
<CustomAuthenticationUI>
<loginUrl>/Pages/UILogon.aspx</loginUrl>
<UseSSL>True</UseSSL>
</CustomAuthenticationUI>
<ReportServerUrl>http://<server>/ReportServer</ReportServerUrl>
</UI>
If you are running the sample security extension in a development environment that does not have a Secure Sockets Layer (SSL) certificate installed, you must change the value of the <UseSSL> element to
False in the previous configuration entry.
If you still have the problem, please post out the two web.config in Report Manager and Report Server and rsreportserver.config file, so that we can check it for further troubleshooting.
Regards,
Edward
TechNet Subscriber Support
If you are
TechNet Subscription user and have any feedback on our support quality, please send your feedback
here.Edward Zhu
TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
July 18th, 2012 3:30am
I was able to make the sample one work. But We I tried to add our custom authentication code it does fail.We have this working on Sql server 2008 SSRS.
I am running Windows 7 on my local machine. [all this is happening in my local machine]
Posting my web.config and ReportServer.config
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<configSections>
<section name="RStrace" type="Microsoft.ReportingServices.Diagnostics.RSTraceSectionHandler,Microsoft.ReportingServices.Diagnostics"/>
<sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
<section name="SSRSExtensions.Security.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false"/>
<section name="SSRSExtensions.Utilities.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false"/>
</sectionGroup>
</configSections>
<applicationSettings>
<SSRSExtensions.Security.Properties.Settings>
<setting name="SSSApplicationFunctionToSSRSGroupMap" serializeAs="Xml">
<value>
<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<string>general application access, CRDBUsers</string>
</ArrayOfString>
</value>
</setting>
<setting name="SSRSExtensions_Security_ReportService2010" serializeAs="String">
<value>http://affectation:5051/ReportServer_SSRS/ReportService2010.asmx</value>
</setting>
<setting name="PluggableServices" serializeAs="Xml">
<value>
<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<string>SSRSExtensions.Security.IValidateUser; SSRSExtensions.Security.SSSUserValidation</string>
</ArrayOfString>
</value>
</setting>
<setting name="MaximumMinutesInCache" serializeAs="String">
<value>30</value>
</setting>
<setting name="CacheFlushIntervalMinutes" serializeAs="String">
<value>5</value>
</setting>
<setting name="AdministratorSSSFunctionName" serializeAs="String">
<value>report server admin</value>
</setting>
<setting name="BackDoorAdministratorName" serializeAs="String">
<value>ucx-reports-new#18259#admin</value>
</setting>
</SSRSExtensions.Security.Properties.Settings>
<SSRSExtensions.Utilities.Properties.Settings>
<setting name="LogLevel" serializeAs="String">
<value>Error</value>
</setting>
</SSRSExtensions.Utilities.Properties.Settings>
</applicationSettings>
<appSettings>
<add key="TraceApplicationName" value="SSRSExtensions.SecurityKatmai"/>
<add key="TraceWebServiceDestination" value="http://ucxtesttraceauditapp.talx.com:9980/TASKAuditWebService/TASKTraceAndAudit.asmx"/>
</appSettings>
<system.diagnostics>
<switches>
<add name="DefaultTraceSwitch" value="3"/>
</switches>
<assert assertuienabled="false"/>
</system.diagnostics>
<RStrace>
<add name="FileName" value="ReportServer_"/>
<add name="FileSizeLimitMb" value="32"/>
<add name="KeepFilesForDays" value="14"/>
<add name="Prefix" value="tid, time"/>
<add name="TraceListeners" value="debugwindow, file"/>
<add name="TraceFileMode" value="unique"/>
<add name="Components" value="all,RunningJobs:3,SemanticQueryEngine:2,SemanticModelGenerator:2"/>
</RStrace>
<system.web>
<customErrors mode="Off"/>
<pages validateRequest="false">
<controls>
<add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
</controls>
</pages>
<!--<authentication mode="Forms" />
<identity impersonate="false" />-->
<authentication mode="Forms">
<!--<forms loginUrl="logon.aspx" name="sqlAuthCookie" timeout="60" path="/" domain=".talx.com"/>-->
<forms loginUrl="logon.aspx" name="sqlAuthCookie" timeout="60" path="/" />
</authentication>
<identity impersonate="false"/>
<authorization>
<deny users="?"/>
</authorization>
<hostingEnvironment shadowCopyBinAssemblies="false"/>
<compilation defaultLanguage="c#" debug="false" tempDirectory="C:\Program Files\Microsoft SQL Server\MSRS10_50.SSRS\Reporting Services\RSTempFiles\">
<assemblies>
<clear />
<add assembly="ReportingServicesWebServer" />
<add assembly="System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<add assembly="System.Web.Services, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</assemblies>
</compilation>
<trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true" />
<sessionState mode="Off" />
<httpHandlers>
<add verb="*" path="Reserved.ReportServer" type="Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler, ReportingServicesWebServer" />
<add verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, ReportingServicesWebServer, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
<add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false" />
</httpHandlers>
<httpModules>
<clear />
<add name="OutputCache" type="System.Web.Caching.OutputCacheModule" />
<add name="WindowsAuthentication" type="System.Web.Security.WindowsAuthenticationModule" />
<add name="FormsAuthentication" type="System.Web.Security.FormsAuthenticationModule" />
<add name="PassportAuthentication" type="System.Web.Security.PassportAuthenticationModule" />
<add name="RoleManager" type="System.Web.Security.RoleManagerModule" />
<add name="UrlAuthorization" type="System.Web.Security.UrlAuthorizationModule" />
<add name="FileAuthorization" type="System.Web.Security.FileAuthorizationModule" />
<add name="AnonymousIdentification" type="System.Web.Security.AnonymousIdentificationModule" />
<add name="Profile" type="System.Web.Profile.ProfileModule" />
<add name="ErrorHandlerModule" type="System.Web.Mobile.ErrorHandlerModule, System.Web.Mobile, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</httpModules>
<globalization requestEncoding="utf-8" responseEncoding="utf-8" />
<httpRuntime executionTimeout="9000" />
<securityPolicy>
<trustLevel name="RosettaSrv" policyFile="rssrvpolicy.config" />
</securityPolicy>
<trust level="RosettaSrv" originUrl="" />
<webServices>
<soapExtensionTypes>
<add type="Microsoft.ReportingServices.WebServer.RsSoapExtension, ReportingServicesWebServer" priority="1" group="1" />
</soapExtensionTypes>
<soapExtensionReflectorTypes>
<add type="Microsoft.ReportingServices.WebServer.RsSoapExtensionReflector, ReportingServicesWebServer" />
</soapExtensionReflectorTypes>
</webServices>
</system.web>
<runtime>
<alwaysFlowImpersonationPolicy enabled="true" />
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="Microsoft.ReportingServices.Interfaces" publicKeyToken="89845dcd8080cc91" culture="neutral" />
<bindingRedirect oldVersion="8.0.242.0" newVersion="10.0.0.0" />
<bindingRedirect oldVersion="9.0.242.0" newVersion="10.0.0.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="Microsoft.ReportingServices.ProcessingCore" publicKeyToken="89845dcd8080cc91" culture="neutral" />
<bindingRedirect oldVersion="9.0.242.0" newVersion="10.0.0.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="msmgdsrv" publicKeyToken="89845dcd8080cc91" />
<codeBase version="9.0.0.0" href="C:\Program Files\Microsoft Analysis Services\AS OLEDB\10\msmgdsrv.dll" />
</dependentAssembly>
</assemblyBinding>
</runtime>
</configuration>
rsReportServer.config
<Configuration>
<Dsn>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAvIUzvepg0kqI28h1Ac4WyQQAAAAiAAAAUgBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAADAAAAAEAAAAFtSpJxO0iAJ94b5rieMnicAAAAA
BIAAAKAAAAAQAAAADRk8vit/QjHAaLWT1Tn4cQABAAD9FMHZrYaFwFij0DaeRzoDGkoqb996O22v
Ct0GLKp+zIpunTzcJ+WFTByUtrGDXqPieO4PWUxS31e2PQ/c0+mAlFyJ8XItMmD2nFAIxkAw8YaH
xiFluzOrNl1Bib6q3d/XPa5rdIVvvCegLI7xEcK6dJBNZBtoASSvMEzJeMrRHKbLeOqXNtknDY/I
pnJfKCwa27OB7AEsAq3JyJe2YXP6IOFKtkfCh6RK1ClxQNBedY9pbaWx2FS2PolC+mKxNBJyD2NE
3+tp9H618svezAjRi5AZkc8+dz5SvmEMtK2jCB2hHcDg1Pd/z388d8NDnizVUVU5qoTFcPBXU4fy
y9HPFAAAAGSEYfLOAZll1KXZRn0qDP6Cy4At
</Dsn>
<ConnectionType>Impersonate</ConnectionType>
<LogonUser>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAvIUzvepg0kqI28h1Ac4WyQQAAAAiAAAAUgBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAADAAAAAEAAAAAPyb/wsWGcTfBINuFQONdQAAAAA
BIAAAKAAAAAQAAAAyLUSBHQueOvk5fI94TA+7RgAAABNANratD6VkqV6cot1mkT5oaQBUTSsJEsU
AAAAFdBuXvC4ydn5k6ZCTB8cgNQZ0zg=</LogonUser>
<LogonDomain>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAvIUzvepg0kqI28h1Ac4WyQQAAAAiAAAAUgBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAADAAAAAEAAAADBCGr20idYjUXX4p+IdNpUAAAAA
BIAAAKAAAAAQAAAAQqvJ31CMCvdPRGgFCnGzbxAAAABqLfzBX97hkSGipqDCc/eCFAAAANkhNCDM
WJ9ctFcZTZQ4aDjTWO9u
</LogonDomain>
<LogonCred>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAvIUzvepg0kqI28h1Ac4WyQQAAAAiAAAAUgBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAADAAAAAEAAAAAQqkBupUzYzpIknG/r+PEIAAAAA
BIAAAKAAAAAQAAAA3oodwrmdGe+GHNQRihc0njAAAABkk2Enc77Mw3po9lqmYK/rXtaRl+zRdrfF
g0eKA2n2HDM2iBM/MmffCf7+EG9PkrQUAAAAlSy2hRMbgjC7EelbHCOryJuNrV4=</LogonCred>
<InstanceId>MSRS10_50.SSRS</InstanceId>
<InstallationID>{df5e01db-9989-4327-bc93-6cc9cf9678bf}</InstallationID>
<Add Key="SecureConnectionLevel" Value="0"/>
<Add Key="CleanupCycleMinutes" Value="10"/>
<Add Key="MaxActiveReqForOneUser" Value="20"/>
<Add Key="DatabaseQueryTimeout" Value="120"/>
<Add Key="RunningRequestsScavengerCycle" Value="60"/>
<Add Key="RunningRequestsDbCycle" Value="60"/>
<Add Key="RunningRequestsAge" Value="30"/>
<Add Key="MaxScheduleWait" Value="5"/>
<Add Key="DisplayErrorLink" Value="true"/>
<Add Key="WebServiceUseFileShareStorage" Value="false"/>
<!-- <Add Key="ProcessTimeout" Value="150" /> -->
<!-- <Add Key="ProcessTimeoutGcExtension" Value="30" /> -->
<!-- <Add Key="WatsonFlags" Value="0x0430" /> full dump-->
<!-- <Add Key="WatsonFlags" Value="0x0428" /> minidump -->
<!-- <Add Key="WatsonFlags" Value="0x0002" /> no dump-->
<Add Key="WatsonFlags" Value="0x0428"/>
<Add Key="WatsonDumpOnExceptions" Value="Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException"/>
<Add Key="WatsonDumpExcludeIfContainsExceptions" Value="System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException,Microsoft.SharePoint.SPException"/>
<URLReservations>
<Application>
<Name>ReportServerWebService</Name>
<VirtualDirectory>ReportServer_SSRS</VirtualDirectory>
<URLs>
<URL>
<UrlString>http://+:5051</UrlString>
<AccountSid>S-1-5-21-422616266-3063631478-1463894030-24041</AccountSid>
<AccountName>TTT\vdsouza</AccountName>
</URL>
</URLs>
</Application>
<Application>
<Name>ReportManager</Name>
<VirtualDirectory>Reports_SSRS</VirtualDirectory>
<URLs>
<URL>
<UrlString>http://+:5051</UrlString>
<AccountSid>S-1-5-21-422616266-3063631478-1463894030-24041</AccountSid>
<AccountName>TTT\vdsouza</AccountName>
</URL>
</URLs>
</Application>
</URLReservations>
<Authentication>
<AuthenticationTypes>
<Custom/>
</AuthenticationTypes>
<RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>
<RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>
<EnableAuthPersistence>true</EnableAuthPersistence>
</Authentication>
<Service>
<IsSchedulingService>True</IsSchedulingService>
<IsNotificationService>True</IsNotificationService>
<IsEventService>True</IsEventService>
<PollingInterval>10</PollingInterval>
<WindowsServiceUseFileShareStorage>False</WindowsServiceUseFileShareStorage>
<MemorySafetyMargin>80</MemorySafetyMargin>
<MemoryThreshold>90</MemoryThreshold>
<RecycleTime>720</RecycleTime>
<MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>
<MaxQueueThreads>0</MaxQueueThreads>
<UrlRoot>http://affectation</UrlRoot>
<UnattendedExecutionAccount>
<UserName></UserName>
<Password></Password>
<Domain></Domain>
</UnattendedExecutionAccount>
<PolicyLevel>rssrvpolicy.config</PolicyLevel>
<IsWebServiceEnabled>True</IsWebServiceEnabled>
<IsReportManagerEnabled>True</IsReportManagerEnabled>
<FileShareStorageLocation>
<Path>
</Path>
</FileShareStorageLocation>
</Service>
<UI>
<CustomAuthenticationUI>
<loginUrl>/Pages/SSSLogin.aspx</loginUrl>
<UseSSL>False</UseSSL>
<PassThroughCookies>
<PassThroughCookie>SSRSCacheCookie</PassThroughCookie>
</PassThroughCookies>
</CustomAuthenticationUI>
<ReportServerUrl></ReportServerUrl>
<PageCountMode>Estimate</PageCountMode>
</UI>
<Extensions>
<Delivery>
<Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<FileShareConfiguration>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
<RenderingExtension>RGDI</RenderingExtension>
</ExcludedRenderFormats>
</FileShareConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer></SMTPServer>
<SMTPServerPort>
</SMTPServerPort>
<SMTPAccountName>
</SMTPAccountName>
<SMTPConnectionTimeout>
</SMTPConnectionTimeout>
<SMTPServerPickupDirectory>
</SMTPServerPickupDirectory>
<SMTPUseSSL>
</SMTPUseSSL>
<SendUsing>2</SendUsing>
<SMTPAuthenticate>
</SMTPAuthenticate>
<From></From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats>
</PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
<RenderingExtension>RGDI</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName>
</DefaultHostName>
<PermittedHosts>
</PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server DocumentLibrary" Type="Microsoft.ReportingServices.SharePoint.SharePointDeliveryExtension.DocumentLibraryProvider,ReportingServicesSharePointDeliveryExtension">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<DocumentLibraryConfiguration>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
<RenderingExtension>RGDI</RenderingExtension>
</ExcludedRenderFormats>
</DocumentLibraryConfiguration>
</Configuration>
</Extension>
<Extension Name="NULL" Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
</Delivery>
<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>
<Render>
<Extension Name="XML" Type="Microsoft.ReportingServices.Rendering.DataRenderer.XmlDataReport,Microsoft.ReportingServices.DataRendering"/>
<Extension Name="NULL" Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering" Visible="false"/>
<Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering"/>
<Extension Name="ATOM" Type="Microsoft.ReportingServices.Rendering.DataRenderer.AtomDataReport,Microsoft.ReportingServices.DataRendering" Visible="false"/>
<Extension Name="PDF" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PDFRenderer,Microsoft.ReportingServices.ImageRendering"/>
<Extension Name="RGDI" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.RGDIRenderer,Microsoft.ReportingServices.ImageRendering" Visible="false"/>
<Extension Name="HTML4.0" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
<Extension Name="MHTML" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering"/>
<Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"/>
<Extension Name="RPL" Type="Microsoft.ReportingServices.Rendering.RPLRendering.RPLRenderer,Microsoft.ReportingServices.RPLRendering" Visible="false" LogAllExecutionRequests="false"/>
<Extension Name="IMAGE" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRenderer,Microsoft.ReportingServices.ImageRendering"/>
<Extension Name="WORD" Type="Microsoft.ReportingServices.Rendering.WordRenderer.WordDocumentRenderer,Microsoft.ReportingServices.WordRendering"/>
</Render>
<Data>
<Extension Name="SQL" Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="SQLAZURE" Type="Microsoft.ReportingServices.DataExtensions.SqlAzureConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="SQLPDW" Type="Microsoft.ReportingServices.DataExtensions.SqlDwConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="OLEDB" Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="OLEDB-MD" Type="Microsoft.ReportingServices.DataExtensions.AdoMdConnection,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="ORACLE" Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="ODBC" Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="XML" Type="Microsoft.ReportingServices.DataExtensions.XmlDPConnection,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="SHAREPOINTLIST" Type="Microsoft.ReportingServices.DataExtensions.SharePointList.SPListConnection,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="SAPBW" Type="Microsoft.ReportingServices.DataExtensions.SapBw.SapBwConnection,Microsoft.ReportingServices.DataExtensions.SapBw"/>
<Extension Name="ESSBASE" Type="Microsoft.ReportingServices.DataExtensions.Essbase.EssbaseConnection,Microsoft.ReportingServices.DataExtensions.Essbase"/>
<Extension Name="TERADATA" Type="Microsoft.ReportingServices.DataExtensions.TeradataConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
</Data>
<SemanticQuery>
<Extension Name="SQL" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MSSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">
<Configuration>
<EnableMathOpCasting>False</EnableMathOpCasting>
</Configuration>
</Extension>
<Extension Name="SQLAZURE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MSSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">
<Configuration>
<EnableMathOpCasting>False</EnableMathOpCasting>
</Configuration>
</Extension>
<Extension Name="SQLPDW" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQLADW.MSSqlAdwSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">
<Configuration>
<EnableMathOpCasting>False</EnableMathOpCasting>
</Configuration>
</Extension>
<Extension Name="ORACLE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Oracle.OraSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">
<Configuration>
<EnableMathOpCasting>True</EnableMathOpCasting>
<DisableNO_MERGEInLeftOuters>False</DisableNO_MERGEInLeftOuters>
<EnableUnistr>False</EnableUnistr>
<DisableTSTruncation>False</DisableTSTruncation>
</Configuration>
</Extension>
<Extension Name="TERADATA" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Teradata.TdSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">
<Configuration>
<EnableMathOpCasting>True</EnableMathOpCasting>
<ReplaceFunctionName>oREPLACE</ReplaceFunctionName>
</Configuration>
</Extension>
<Extension Name="OLEDB-MD" Type="Microsoft.AnalysisServices.Modeling.QueryExecution.ASSemanticQueryCommand,Microsoft.AnalysisServices.Modeling"/>
</SemanticQuery>
<ModelGeneration>
<Extension Name="SQL" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MsSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/>
<Extension Name="SQLAZURE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MsSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/>
<Extension Name="ORACLE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Oracle.OraSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/>
<Extension Name="TERADATA" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Teradata.TdSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/>
<Extension Name="OLEDB-MD" Type="Microsoft.AnalysisServices.Modeling.Generation.ModelGeneratorExtention,Microsoft.AnalysisServices.Modeling"/>
</ModelGeneration>
<!--<Security>
<Extension Name="Windows" Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization, Microsoft.ReportingServices.Authorization"/>
</Security>-->
<Security>
<Extension Name="Forms" Type="SSRSExtensions.Security.Authorization, SSRSExtensions.Security">
<Configuration>
<AdminConfiguration>
<UserName>administrator</UserName>
</AdminConfiguration>
</Configuration>
</Extension>
</Security>
<!--<Authentication>
<Extension Name="Windows" Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication, Microsoft.ReportingServices.Authorization"/>
</Authentication>-->
<Authentication>
<Extension Name="Forms" Type="SSRSExtensions.Security.Authentication, SSRSExtensions.Security"/>
</Authentication>
<EventProcessing>
<Extension Name="SnapShot Extension" Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,ReportingServicesLibrary">
<Event>
<Type>ReportHistorySnapshotCreated</Type>
</Event>
</Extension>
<Extension Name="Timed Subscription Extension" Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,ReportingServicesLibrary">
<Event>
<Type>TimedSubscription</Type>
</Event>
</Extension>
<Extension Name="Cache Refresh Plan Extension" Type="Microsoft.ReportingServices.Library.CacheRefreshPlanHandler,ReportingServicesLibrary">
<Event>
<Type>RefreshCache</Type>
</Event>
</Extension>
<Extension Name="Cache Update Extension" Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEventHandler,ReportingServicesLibrary">
<Event>
<Type>SnapshotUpdated</Type>
</Event>
</Extension>
</EventProcessing>
</Extensions>
<MapTileServerConfiguration>
<MaxConnections>2</MaxConnections>
<Timeout>10</Timeout>
<AppID>(Default)</AppID>
<CacheLevel>Default</CacheLevel>
</MapTileServerConfiguration>
</Configuration>
vivek
July 25th, 2012 11:27am
Hello vivek,
Thank you to post out the modified configuration files.
After reviewing the code, I found that there is a code mistake. I consider that the form login page is
logon.aspx. Please try to change the UI tag in the rsreportserver.config. Replace the original loginUrl with the real one.
<UI>
<CustomAuthenticationUI>
<loginUrl>logon.aspx</loginUrl>
<UseSSL>True</UseSSL>
</CustomAuthenticationUI>
<ReportServerUrl>http://<server>/ReportServer</ReportServerUrl>
</UI>
I hope it could be helpful to you. If you have any questions about this issue, please tell us freely.
Regards,
Edward
TechNet
Subscriber Support
If you are TechNet
Subscription user and have any feedback on our support quality, please send your feedback here.
Edward Zhu
TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
July 25th, 2012 11:40pm
The <UI> Section in rsreportserver.config is for report manager. the login url is correct as per my config.
I am on Windows 2008 R2 and development machine is on Windows 7. Looks like httpcontext in these machines are not getting set corrrectly. So it is coming as null all the time. have you encountered these issue?
Thanks
Vivek
vivek
July 31st, 2012 11:49am
Hello vivek,
I am sorry for my delay.
I think we need to check whether the issue is still same with the original one. It is possible that the error message is different though the behavior is very similar. Then, we need analyze this issue based on the new error and to see how to solve it. Therefore,
please check the error on the report server first. If it is different with the original, please post it out.
Regards,
Edward
TechNet
Subscriber Support
If you are TechNet
Subscription user and have any feedback on our support quality, please send your feedback here.
Edward Zhu
TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
August 3rd, 2012 2:32am