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