Getting SSRS 2005 to work on Server 2008 R2
I reinstalled SQL Server 2005 x64 Standard Edition SP3 on a Server 2008 R2 box and installed IIS and SSRS as well. SQL runs fine. SSRS is installed all configs look good, but I cannot get it accessible via the browser (//localhost/ReportServeror //localhost/Reports). I have tried both 32 & 64 defaults in IIS AppPools and each gives me an error and I can't find any other resources as to what the problem is? 32-bit setting is giving me this error on /ReportServer: Could not load file or assembly 'ReportingServicesNativeClient, Version=0.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. An attempt was made to load a program with an incorrect format. 64-bit setting is giving me this error on /ReportServer: HTTP Error 500.0 - Internal Server Error, Error Code 0x800700c1 32 & 64-bit setting are both giving me this error on /Reports: HTTP Error 401.2 - Unauthorized, Error Code0x80070005
October 7th, 2010 4:02pm

Okay I was able to get past this error by installing the latest Cumalative updates (http://hotfixv4.microsoft.com/SQL%20Server%202005/sp3/SQLServer2005_SP3_CU11_2258854_9_00_4309/9.00.4309/free/418737_intl_x64_zip.exe ) But now am getting the following error from /ReportServer: Reporting Services Error The permissions granted to user 'Domain\User' are insufficient for performing this operation. (rsAccessDenied) Get Online Help SQL Server Reporting Services But /Reports just hangs up and never loads. Any suggestions?
Free Windows Admin Tool Kit Click here and download it now
October 7th, 2010 6:35pm

Okay getting further... I changed my Window Service Identity to "Network Service" instead of "Local System" in SSRS Config Mgr. Now /ReportServer just comes up with blank page with just the URL and SSRS Version, but only if I run IE as Admin. /Reports on the other hand still hangs up and will hang up /ReportServer also until service is restarted. Still need some help if anyone has it.
October 7th, 2010 7:16pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics