SSRS 2008 Custom Authentication works when using ReportServer url but not when report manager url is used
Hi, I am using SSRS 2008 with Custom security extension for authentication. The extension is developed in c#. I have placed the dll under report server bin and report manager bin directory and the logon,login pages under appropriate directory. My reports manager url is http://localhost:port/Reports and my reports server url is http://localhost:port/ReportServer. When I try to login through reports manager url, I am getting 'login failed' error message from the dll. But when I try to login using reports server url, it works. I have also set 'FullTrust' named permission set in RSMgrPolicy.config . <CodeGroup class="FirstMatchCodeGroup" version="1" PermissionSetName="FullTrust" Description="This code group grants MyComputer code Execution permission. "> < IMembershipCondition class = " ZoneMembershipCondition " version = " 1 " Zone = " MyComputer " /> Any suggestions please! Thanks!
July 14th, 2010 10:31pm

Hi schandr, The detailed error message will help us to solve the issue. If possible, could you please post it? Just based on my experiences, there should have some configurations to check: 1. <ReportServerUrl> is configured correctly in the rsreportserver.config. 2. CodeGroup is configured correctly in both rssrvpolicy.config and rsmgrpolicy.config. In rsmgrpolicy, the URL should be C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager\bin\customassembly.dll In rssrvpolicy.config, C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\bin\customassembly.dll Please note, there is different between the URL(Report Manager and ReportServer). 3. <UseSSL> is False if the SSL is not configured. 4.<add key="ReportServer" value="<Server Name>"/> <add key="ReportServerInstance" value="<Instance Name>"/> are configured correctly in the Web.config for Report Manager. ReportServer is the machine name. ReportServerInstance is "RS_<instance name>" If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
July 16th, 2010 1:50pm

Hi Jin, Thanks for your reply. Sorry for unmarking the answer. The problem still happens. I checked all the above parameters and we are not using SSL. I checked the following logs - report server logs, event viewer logs and also turned on the http.sys log. Few more details on the configuration: The reports manager and report server URL are accessed using external IP. Now when I captured the events using wireshark accessing both URL, I can see the 'sqlAuthCookie' getting transmitted from the server while accessing the report server url, but the same does not happen using reports manager URL. Also in the report server config.exe under the reportserver/bin directory I turned on the trace switch and also included http tracing at level 4. Below is the log we got from the reportserver http log #Software: Microsoft SQL Server Reporting Services Version 2007.0100.2531.00 ((Katmai_PCU_Main).090329-1045 ) #Version: 1.0 #Date: 09/02/2010-20:54:08 #Fields: time c-ip cs-method cs-uri-stem sc-status 20:54:08 4.79.200.2 GET /Reports 302 20:54:14 192.168.178.10 POST /reportserver/ReportService2005.asmx 302 20:54:14 192.168.178.10 GET /ReportServer/logon.aspx 200 20:54:16 4.79.200.2 GET /Reports/Pages/Folder.aspx 302 20:54:16 4.79.200.2 GET /Reports/Pages/UILogon.aspx 200 20:54:31 192.168.178.10 POST /ReportServer/ReportService2005.asmx 200 20:54:32 4.79.200.2 POST /Reports/Pages/UILogon.aspx 302 20:54:32 192.168.178.10 POST /reportserver/ReportService2005.asmx 302 20:54:33 192.168.178.10 GET /ReportServer/logon.aspx 200 20:54:34 4.79.200.2 GET /Reports/Pages/Folder.aspx 302 20:54:34 4.79.200.2 GET /Reports/Pages/UILogon.aspx 200 20:54:48 192.168.178.10 POST /ReportServer/ReportService2005.asmx 200 20:54:48 4.79.200.2 POST /Reports/Pages/UILogon.aspx 302 20:54:48 192.168.178.10 POST /reportserver/ReportService2005.asmx 302 20:54:49 192.168.178.10 GET /ReportServer/logon.aspx 200 20:54:50 4.79.200.2 GET /Reports/Pages/Folder.aspx 302 20:54:50 4.79.200.2 GET /Reports/Pages/UILogon.aspx 200 And we didn't see any errors in the reportserverService log. Please advise. We tried to google a lot but it was of no use. Thanks in advance for your reply. Thanks, Schandr
September 3rd, 2010 6:00pm

We do have the same issue and please share the resolution for this issue if you got working. Thanks.
Free Windows Admin Tool Kit Click here and download it now
September 9th, 2010 5:19pm

Any Luck on this? Thanks
September 30th, 2010 6:54pm

I am updating the question which I posted earlier. We still have the issue. But below are few things we tried. 1. We turned on the debug for the custom extension DLL which was used for authentication and authorization. The logs shows no error when we Reports manager URL was accessed internally and externally. 2. Modified the reports manager and the report server URL to use the machine name instead of IP. Still same issue 3. One thing we found while debugging the issue was a snippet of code in our custom authentication which overrides the GetWebResponse and GetWebRequest methods of ReportServerProxy to relay the cookie to the client. Since the custom extension is responsible to pass the cookie to the browser, we are setting the domain as follows: HttpCookie webCookie = new HttpCookie(netCookie.Name, netCookie.Value); if (netCookie.Domain.IndexOf('.') != -1) { webCookie.Domain = netCookie.Domain; } webCookie.Expires = DateTime.Now.AddHours(12); webCookie.Path = netCookie.Path; webCookie.Secure = netCookie.Secure; return webCookie; The Domain attribute of the cookie is set to the IP configured in the reports configuration tool ( which is the internal IP). We were wondering if that could be the issue. Please help. It is very urgent. Thanks!
Free Windows Admin Tool Kit Click here and download it now
December 20th, 2010 12:58pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics