Monday, February 20, 2012

Reporting Services X64 major problem

Hi,

We have a product that is developed in ASP and works with SQL Server 2000 or 2005. Since it’s an ERP, we also use Reporting Services 2000 or 2005. Our application needs 3 registered DLLs that were, a long time ago, developed to support our entire application.

Since we are using Windows Server 2003 x64 editions in our clients with SQL Server 2005 x64 edition, we managed to register the 32 bit DLLs in the 64 bit system. We installed them as a COM+ component, ran the command “cscript.exe adsutil.vbs set W3SVC/AppPools/Enable32BitAppOnWin64 true” and our application worked fine.

This command caused the IIS to use the .NET 2.0 32 bit version so that our DLLs could be correctly invoked.

But now Reporting Services doesn’t work because it needs the 64 bit version of the .Net framework. When I try to connhecto to localhost/reports, I get the error "%1 is not a valid Win32 application".

Is there any workaround to this problem so that i can deploy the application and the database in the same machine?

This means that there is no way to install SQL Server 2005 x64 and Reporting Services X86 in the same machine...?

No comments:

Post a Comment