No connection could be made because the target machine actively refused it or The operation you are attempting requires a secure connection (HTTPS)

We could receive the above errors while trying to connect to the reporting server from SQL server management studio or while importing organization using Deployment Administrator.

The following changes resolved the issue

Go to reports server’s config file

1) C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\RSWebApplication.config

<ReportServerUrl>http://servername/ReportServer</ReportServerUrl>

<UrlRoot>http://servername/reportserver</UrlRoot>

Change https to http

2) C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\rsreportserver.config

<Add Key="SecureConnectionLevel" Value="0"/>

Change the Value from 2 to 0

Verify the 3rd step as well

3) In IIS, right click the web site –> properties –> Directory Securities –> Authentication and access control –> Edit

Disable the anonymous access

bye..

Author: Nishant Rana

I love working in and sharing everything about Microsoft.NET technology ! View all posts by Nishant Rana