Configuring SSRS

I was configuring SSRS (SQL Server Reporting Services) to run locally on my new developement machine, and I ran into some problems that I haven’t encountered before. No matter the configuration settings, in Internet Explorer when I tried to open the Report Manager I kept getting the error:

The underlying connection was closed: An unexpected error occurred on a send.

In the SSRS log file (my logfile was found in the folder “C:\Program Files\Microsoft SQL Server\MSRS11.SS2012\Reporting Services\LogFiles”), the following error was found:

System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a send. —> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. —> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host.

To resolve this issue, I had to manually edit the file rsreportserver.xml (backup the file before you do that!) found in “C:\Program Files\Microsoft SQL Server\MSRS11.SS2012\Reporting Services\ReportServer” on my machine. Edit the Add Key=”SecureConnectionLevel” Value=”2″ setting so that the value is 0, not 2 or 1. In effect, this tells SSRS to not use SSL when connecting to the Report Manager. So if you do want to use SSL, this fix is not for you. The solution presented here will remove all encryption from the connection, but since I’m doing this on my development machine, that is ok.

You may not be able to save your changes directly if SSRS has a lock on the file. So stop the SSRS service, save your changes in the file, and start the SSRS service again.

Check if the Report Manager can be opened after the service has started. In my case, the error was gone but replaced with a more familiar one:

User ‘DOMAIN\USER’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

This error is easy to fix and I have had it every time I install SSRS on a new machine. Just run Internet Explorer as Administrator and add yourself (current user) as System Administrator under the “Site Settings” page (link in the top right part of the start page).

Also add yourself as user in the Home folder by pressing the button “Folder Settings” from the start page.

Good luck!

Leave a Reply

Required fields are marked *.