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).”
Update the RSReportServer.config file using the following steps:
- 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
- Right-click RSReportServer.config, click Open With, click Notepad and then click OK.
- Locate the following Add Key entry: <Add Key="SecureConnectionLevel" Value="2"/>
- Change the Value setting from 2 to 0.
The following are accepted as inputs for the secureconnectionlevel key.
| Level |
Description |
Web Methods Requiring SSL |
| 0 |
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. |
None. |
| 1 |
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. |
| 2 |
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. |
| 3 |
Most secure. All calls made to the Reporting Services SOAP API require a secure connection. |
All. |
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See
Terms of Use
(http://go.microsoft.com/fwlink/?LinkId=151500)
for other considerations.