March 13, 2009 at 3:22 am
Hi all,
I've installed SQL Server 2005 Developer Edition, 64-bit, on my 64-bit Vista computer. The installation went ok, and I applied SP2, and all services start and run ok. However, when I try to access the Reports Manager at http://localhost/reports, I get the following error:
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.
I'm sure it's a 64-bit problem but I don't know how to solve it. Any help would be appreciated.
best regards
Chay
September 28, 2009 at 9:57 am
I'm getting the same thing on Server 2008 x64 and from the research I've done, it does appear to be 64/32 bit issue. Unfortunately that's about all I've been able to gather as I still don't have a fix. I note your post was quite a long time ago - did you ever resolve the problem and if so how?
Regards
Robert
September 28, 2009 at 10:41 am
Hi Robert,
I did indeed post that some time ago, and I've forgotten where I finally found out that you need to install the 32-bit version of Reporting Services for it to work.
What I did was completely uninstall SQL Server Dev. Edition, then I re-installed it, omitting Reporting Services. Then I installed the 32-bit version of Reporting Services, and it worked fine.
I know that's not too detailed but I hope it works for you.
regards
Chay
September 29, 2009 at 1:49 am
Hi Chay
Since my posting I have discovered the answer (or at least the answer that worked for my circumstances). The problem was the IIS setting 'Enable32BitAppOnWin64' (in the list of applications in the Application Pool, right-click ReportServer and choose 'Advanced Settings...') which was set to 'True'. The setting name is something of a misnoma and would more helpfully be named 'Use32BitAppOnWin64' because that is what it does. If you set this to 'False' and restart the IIS ReportServer application, the error goes away because I have a 64-bit version of SSRS installed.
You solved it from the other direction by changing the version of SSRS to a 32-bit one (although I should say that when I eventually found the setting, my method was less hassle!). I don't know which version of IIS comes with Vista X64 but the method I describe above is for IIS 7 which supports a different value for 'Use32BitAppOnWin64' per application in the application pool and allows you to change it via the UI. As I understand it, although IIS 6 supports this setting, it works for the whole IIS installation (rather than an individual application within the application pool) and needs to be set using a script:
cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 0
So anyone running IIS 6 and ReportServer in conjunction with other IIS applications that only run in 32-bit mode would actually be forced to use the 32-bit version of SSRS.
Regards
Robert
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply