Archive for August, 2012

SSRS Cannot Access Report Manager Home Page On Default URL

August 6, 2012

Semi-loyal fans: just a quick nibble today…

My team lead installed SQL Server Reporting Services on my DEV machine and asked me to ‘get it working’. Both of us are noobs at SSRS installation.

I found that SSRS was indeed installed by opening the Reporting Services Configuration Manager but I could not access the Report Manager home page which was at http://machinename/ReportServer_SQL2008R2.

After a lifesource-draining 67 mins. of googling, the answer was of course incredibly simple.

The URLs http://machinename and http://localhost need to be added as Trusted Sites in Internet Explorer. To do this, run IE in Adminstrator Mode and follow instructions kindly supplied by Microsoft Support Knolwedge Base here. See instructions and point 7 “Configure Report Server for Local Administration”.

For this glorious solution I thank of course Microsoft Support and the linkee Anitha6320269, currently scoring 0 points on the social msdn forums with no recorded recent achievements. Anitha, may your score increase to levels beyond your nick!

UPDATE: Two Hours Later

Weird. A couple of hours later I could not access the Report Server Page. I was only getting a Directory Listing of the Report Server site, not the actual landing page. So I had to turn off Windows user Account Control. I did that by following this link.

Deploying Reports To The SSRS Report Server

Cool. I can see an SSRS page. Now, how to stuff my Reports in there. What you need to do is the following:

– Create a SSRS Report in a Report Server Project using Visual Studio 2008 (VS 2010 doesn’t have Report Server Projects yet)
– In Properties for that Project specify the TargetReportFolder and TargetServerURL

The Target Server URL is not the same as your Report Server URL. The reason for this is that the TargetServerURL attribute in Properties refers to