Configuring SQL Report Server 2008 SP1

When configuring a SQL 2008 SP1 reporting server I got this error, “The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel”  when I trying to view the http://servername/Reports url. This appeared a bit odd as I wasn’t trying to connect via SSL to the site.

 

image

Luckily the fix here was an easy one, I simply had to alter the “rsreportserver.config” file and make the following change.

From:

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

To:

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

Which resolved the issue and displayed the page.

image

 

There is more detail on this here. This basically means that this will need to be revisited again when it comes time to enable reporting services out to the web via an SSL.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: