When you install Microsoft Dynamics CRM with SQL 2008 Reporting Services the following error occurs in the Environmental Diagnostics Wizard (EDW):

Setup failed to validate specified Reporting Services Report Server  <ReportServerURL>. Error: The operation you are attempting requires a secure connection (HTTPS).”


The error occurs because the SSRS server is configured to accept connections only via HTTPS.


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.


The following are accepted as inputs for the secureconnectionlevel key.



Web Methods Requiring SSL


Least secure. The report server does not check for a secure connection when Web service methods are invoked. However, all calls to the Web service can still be made to the report server over a secure connection.



Minimally secure. All Web service calls that are made over an insecure connection and which might pass sensitive data such as user credentials are rejected. However, this setting does not guarantee security. It is still possible for sensitive data sent by the client to the report server to be exposed before the report server handles the request and rejects it.

Render (when the credential setting for the report that is being rendered is set to prompt), CreateDataSource, GetDataSourceContents, SetDataSourceContents, GetReportDataSources, SetReportDataSources, CreateReport, GetReportDefintion, SetReportDefinition, CreateDataDrivenSubscription, SetDataDrivenSubscriptionProperties, GetDataDrivenSubscriptionProperties, and PrepareQuery.


Secure. All rendered reports and all Web service calls require a secure connection. This includes all calls to the Render method and requests for rendered reports made through URL access. Using this secure connection level, subscription delivery can include only URLs to reports. Rendered reports cannot be embedded or included in a delivery.

All Level 1 methods, Render (all calls), and RenderStream.


Most secure. All calls made to the Reporting Services SOAP API require a secure connection.


More Information

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!