SSRS 2008 R2 After using SSL, In Report Manager new datasource link, upload file link, subscription links not working.it shows http instead https.
Hello, I have provided my setting and environment information below. My goal is to set Report Manager and Report Server URL with SSL connection so all URLs uses HTTPS (Secure connection) all the time. and remove HTTP access . I applied following settings for this but I am getting errors. With Current Settings that I mensioned below, I am able to login into WebService URL successfully with all links working. For Report Manager URL I logged in successfully but for some pages I am getting HTTP links instead HTTPS. It shows HTTP links for new datasource link, upload file link, subscription links so it shows blank page I tried to look for solution and I applied but did not worked. I did some experiment with changing urls using application and manually from RSReportServer.config file but still not succedded. Steps taken to solve problem: To force to use HTTPS only, I tried to change SecureConnectionLevel = 0 to 1,2 or 3 but when accessing to Report Manager it gives 401 Authentication error. If I remove http://+:80/ReportServer and tried to visit 2nd URL with HTTPS. The Web Service URL opens successfully. but Report Manager url gives me error 'request failed with HTTP status 401: Unauthorized' To solve 401: Unauthorized error, I followed this article http://technet.microsoft.com/en-us/library/ms159778.aspx but not solved my error. I tried to set ReportServerUrl also as shown below. <UI> <ReportServerUrl>http://rs.test.abc.com/reportserver</ReportServerUrl> <PageCountMode>Estimate</PageCountMode> </UI> Reporting Service configuratin tool setting Web Serivice URL - 1st URL) http://+:80/ReportServer 2nd URL) https://rs.test.abc.com:443/ReportServer Report Manager URL - https://rs.test.abc.com:443 RSReportServer.config file settings SecureConnectionLevel = 0 Environment - Distributed deployment Server1(report_srv) --Windows server 2003R2 64bit, Installed sql server 2008R2 reporting service, configuration tools Server2 (report_db_srv) --windows server 2003r2 64bit, sql server 2005 for report server database (Note: I am using domain user. Report Server and User both are in different domain. but everything was working fine on port 80 without SSL with default settings i.e. http://fully domain name/Reports ) Thanks
July 14th, 2010 2:12am

Hi, I resolved this issue now. Here I am providing the solution. This might helps someone too. As I mensioned when I try to set SecureConnectionLevel = 3 into RSReportServer.config file. I was getting error when accessing to Report Manager. it gives 401 Authentication error. steps for Solution Step 1) Goto Start\Run and type Regedit to open Registry. Add new a DisableLoopbackCheck value (edit value 0 for disable) to the HKEY_Local_Machine\System\CurrentControlSet\Control\Lsa key. (Note: Backup registry before you change it. You can use export option from top manu) Step 2) Goto RSReportServer.config file and set SecureConnectionLevel value to 3 Step 3) Restart Reporting Service from Reporting Service Configuration Tool. Result: Successfully solved the problems. Now I am successfully logged in on Report Manger and all links works with HTTPS only.
Free Windows Admin Tool Kit Click here and download it now
July 15th, 2010 2:13am

I read through your solution. However, i am looking at a solution where i dont have to use to SecureConnectionLevel = 3 . We dont want the user to enter into the windows authentication box, everytime they open a new browser. Is there away for the SSL to work with SecureConnectionLevel = 0??(First question)Will the same change work?? Also, is it a true secure site with SecureConnectionLevel = 0??Can we use SecureConnectionLevel = 0??(Second question)
August 6th, 2010 9:56pm

Answer 1,2 . You can read it from http://msdn.microsoft.com/en-us/library/ms143200.aspx Moderator Jin Chen have provided answer for integrated login. Usually, if the Report Server is configured to use Window Integrated Security, the users in the domain will be verified automatically. For the prompted login dialog issue, it may be caused by the Internet Explorer(IE) does not pass the users' credential to the Report Server automatically. We can add the Report Server sites to the local sites zone or security zone, and set the "Auto logon with current username and password" to fix this issue: 1. Open IE, click the menu "Tools" >> "Internet Option..." 2. Go to "Security" tab. 3. Select "Intranet Sites" zone or "Security" zone. 4. Click "Add" to add the Report Server sites(Report Manager URL and Web Service URL) to that zone. 5. Click "Custom Level", and check the item "Auto logon with current username and password". Pasted from http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/c0fbe51f-f289-41ca-8987-7aabe25595ac Let me know if you have any question. - Kunal
Free Windows Admin Tool Kit Click here and download it now
August 6th, 2010 10:39pm

Hi Kunal, Excellent job! Great sharing the information, Thanks very much.
August 9th, 2010 5:10am

In order to disable the authentication loopback check, the DisableLoopbackCheck value must be set to 1. Click Start, click Run, type regedit, and then click OK. Locate and then click the following registry subkey: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa Right-click Lsa, point to New, and then click DWORD Value. Type DisableLoopbackCheck, and then press ENTER. Right-click DisableLoopbackCheck, and then click Modify. In the Value data box, type 1, and then click OK. Exit Registry Editor. Setting the DisableLoopbackCheck value to 1 corrected the 401 Not Authorized problem. I now have the SecureConnectionLevel value set to 3 in the rsreportserver.config and all traffic is going over SSL.
Free Windows Admin Tool Kit Click here and download it now
October 1st, 2010 1:40am

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

Other recent topics Other recent topics