SQL Server 2005 Express & Windows Reporting services

Hot Topic

No Values in Dropdowns
SQL Backup: Database needs to be in single user mode.
Need help to install sql reporting services
Windows 64 bit and Oracle
Quick way to Round all fields
Making outbound HTTP requests from SQLCLR
Error while importing Text file using Import Export Wizard
Fuzzy Grouping errors
Report Builder - Editing existing report
SQL Mobile query hangs PPC 2003 device

SQL Server

How reliable is Microsoft's type4-JDBC driver for MsSQL Server????
Databases not appearing in ODBC configuration
Is this possible?
About The Connect to Server Dialog
Hidden items, whitespace
Enable/Disable Job with SMO
How do you use the upgrade.exe for sqlce 2.0 to sqlce 3.0?
Swapping partitions in SSAS 2005
Changes not replicated to subscriber
SQL Mobile Installation Problem on Device

SQL Server 2005 Express & Windows Reporting services

Hi,

I've just installed SQL Server Express 2005 on our shiny new Windows Server 2003 R x64 server. It has an Intel 830 D chip that uses x86 and 64EMT.

Problem is that I get the message "64-bit ASP.Net is Registered. Required 32-bit ASP.Net to install Microsoft Reporting Services 2005(32-bit)."

Is there any way that I can remedy this

Thanks in advance

Robert

Answer this question

SQL Server 2005 Express & Windows Reporting services

  • Andre A

    Thanks Jeff. That sounds like the very thing. I will try it out in the morning.

    btw where do I obtain a copy of dotnetfx64.exe

    Cheers, Robert

  • devudu

    Hi,

    I'm having the same type of problems on a vista professionnal 64 bits.

    I'm developping with Visual studio 2005 (English version). I also have trought uy partner program a licence for SQL server 2005 standard edition (but in French this time).

    So my question is : should I use the same technique that's described here to be able to develop reports and reports models, or should I rather use the Standard edition in French

    Buck

  • Harry1311

    Hi Robert,

    dotnetfx64.exe is what we ship on the DVD of SQL Server, which I believe is renamed on our media (if you download the 64-bit .NET 2.0 framework it is named dotnetfx.exe). If you already have the 64-bit version of the .NET Framework 2.0 then you don't need to install it using dotnetfx64.exe.

    jeff.



  • AlexWeatherall

    Hi Robert,

    This should fix your problem (taken from the SQL Server 2005 Readme):

    2.5.13 Configure IIS to Run 32-bit Reporting Services in WOW64 Mode

    This readme item provides an updated version of the "How to: Configure IIS to Run 32-bit Reporting Services in WOW64 Mode" topic. Use the following steps to run Reporting Services in Windows-on-Windows 64 (WOW64) x86 emulation mode. Use the version of ASP.NET 2.0 that is provided through dotnetfx64.exe.

    To configure IIS to run 32-bit Reporting Services in WOW64 mode:

    1. Uninstall the 64-bit version of Reporting Services. Side-by-side deployment of 64-bit and 32-bit versions is not supported.

    2. Run dotnetfx64.exe to install the .NET Framework manually. You can find this file in the Redist subfolder on the SQL Server 2005 installation media or in the directory that contains the extracted product installation files.

    3. In IIS Manager, click the Web Server Extensions folder. In the Details pane, right-click ASP.NET V2.0.50727, and then click Allowed.

    4. Right-click the Web Sites folder, and then select Properties.

    5. Click ISAPI Filters. In Filter Name, select ASP.NET_2.0.50727, and then click Edit.

    6. Replace "C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\aspnet_filter.dll" with the 32-bit version that is located in the Framework folder: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_filter.dll

    7. Click OK. Save your changes, and then close IIS Manager.

    8. From the command prompt, run the following command:

      cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1

    9. Install the 32-bit version of Reporting Services. After setup is complete, open IIS Manager, click the Web Server Extensions folder. In the Details pane, right-click ASP.NET V2.0.50727(32-bit), and then click Allowed.

    Jeff.



  • SQL Server 2005 Express & Windows Reporting services
Answer this question