Pages

Wednesday, October 31, 2012

SSRS the operation you are attempting requires a secure connection (https)


I stumbled upon an issue where SSRS was not HTTPS but could kept getting the following error:
 The operation you are attempting requires a secure connection (https)
Here is what I did to fix the issue.
Update the RSReportServer.config file using the following steps:
  1. In Windows Explorer, locate the ReportServer directory. The following path is the default path of this directory: C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer
  2. Right-click RSReportServer.config, click Open With, click Notepad and then click OK.
  3. Locate the following Add Key entry: <Add Key="SecureConnectionLevel" Value="2"/>
  4. Change the Value setting from 2 to 0.

Tuesday, October 23, 2012

SSMS 2012 Report Security Bug

Looks like in SQL Server 2012 there is an issue with some base reports that come with SSMS. Here is a link that provided me guidance.

http://dbfriend.blogspot.com/2012/10/ssms-report-security-bug.html?goback=%2Egde_137774_member_177201860