Saturday, October 16, 2010

Resolve first issue in SSRS 2008

After you install SSRS 2008 and run/deploy your first report there is 99% chance that you will get an error message as follows.

The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.

If we google it, we will get directions like check your settings of IIS where the service is hosted…But this is mainly for SSRS 2005 which uses IIS for hosting the services.SSRS 2008 is not using IIS, as it has its on server mechanism which overrides 80 port of IIS.

Confused???When an request comes to the system through the port 80, SSRS 2008 will process it before IIS gets the request.That means there is no web.config of IIS to change the SSL settings.But there is another file rsreportserver.config located at the below location to configure the settings.

[Install drive]:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer

This file contains an entry keyed as “SecureConnectionLevel” defaulted to 2.Change this to 0 to disable SSL.

Enjoy reporting…

No comments: