Learn more about SQL Server tools

 

Tutorials          DBA          Dev          BI          Career          Categories          Videos          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Events

DBA    Dev    BI    Categories

 

Install SQL Server Reporting Services 32 bit on a 64 bit Windows Server


By:   |   Read Comments (11)   |   Related Tips: > Reporting Services Installation

Problem
You have a Windows 64-bit server and need to install the 32-bit version of SQL Server 2005 Reporting Services on this machine. In this tip I will walk through the steps you need to take for this installation.

Solution
I've seen customers that have either Windows Server 2003 or 2008 64-bit machines, but needed to install a 32-bit version of SQL Server 2005 Reporting Services. This would require installing the 32-bit version of ASP.NET 2.0 running on top of IIS.

By default, IIS runs 64-bit on a 64-bit Windows. While Microsoft recommends running 64-bit applications on 64-bit OS to take full advantage of the 64-bit platform, some customers might need to re-use their existing license instead of buying a new one, thus, having to deal with this situation. You'll see the error message below when you attempt to install SQL Server 2005 Reporting Services 32-bit on a Windows Server 64-bit


Configuring Windows Server 2003 64-bit to run IIS 6 on 32-bit

Installing SQL Server 2005 Reporting Services 32-bit on a Windows Server 2003 64-bit requires having both ASP.NET 2.0 32-bit and IIS 6.0 configured to run 32-bit web applications. With Windows Server 2003 Service Pack 1, IIS 6.0 can be enabled to run 32-bit applications on a 64-bit Windows using the Windows32-On-Windows64(WoW64) compatibility layer. This makes it possible to run ASP.NET 32-bit and other 32-bit web applications as well as allow creation of 32-bit worker processes within IIS. The disadvantage of this is that, once you've configured IIS 6.0 to run on 32-bit, you won't be able to run other 64-bit web applications, making it a dedicated server for your 32-bit web applications. It is important to configure IIS prior to installing SQL Server 2005 Reporting Services as the installation process will throw an error like the one in the screenshot above.

To enable IIS 6.0 to run 32-bit web applications on a 64-bit Windows, navigate to the %windir%\Inetpub\AdminScripts directory and run the adsutil.vbs script with the following parameters.
 

cscript.exe adsutil.vbs set W3SVC/AppPools/Enable32BitAppOnWin64 "true"

This will enable IIS 6.0 to run 32-bit web applications - these steps are also outlined in this Microsoft TechNet article which applies to just about any 32-bit web applications, including ASP.NET. You can, then, install SQL Server 2005 Reporting Services 32-bit which will install the corresponding ASP.NET 2.0 as part of the .NET Framework installation. If, however, you already have the .NET Framework installed on the server prior to installing SQL Server 2005 Reporting Services, you will need to manually install ASP.NET 2.0 32-bit on IIS 6.0 after it has been configured to run 32-bit web applications, otherwise, you'll get the same error as the one in the above screenshot.

Navigate to the %WINDIR%\Microsoft.NET\Framework\v2.0.50727 folder (the 64-bit version of the .NET Framework will be at the %WINDIR%\Microsoft.NET\Framework64\ folder). Run the aspnet_regiis.exe utility on the command line.

aspnet_regiis -i

You can now proceed to install SQL Server 205 Reporting Services 32-bit on your Windows Server 2003 64-bit running IIS 6.0.


Configuring Windows Server 2008 64-bit to run IIS 7 on 32-bit

In case you have a Windows Server 2008 64-bit machine, there's a bit more work to do than just installing IIS and configuring it in 32-bit mode. SQL Server 2005 Reporting Services depends on the IIS 6 or earlier metabase. So, even though you already have IIS 7 installed, you will still encounter an error similar to the one in the below screenshot.

The good thing about IIS 7 is that it supports IIS 6 backward compatibility thru the IIS 6 Metabase Compatibility and IIS 6 WMI Compatibility. Installing these two would also configure the IIS Default Application Pool to run on 32-bit similar to running the adsutil.vbs script for Windows Server 2003. To install these two options, you can either add them in the Add Role Services in IIS 7, in case it is already installed, or configure them by using the Add Roles option under Server Manager. In my case, I already have IIS 7 installed so I just added the IIS 6 Metabase Compatibility and IIS 6 WMI Compatibility options using the Add Role Services option.

If, for some reason, this does not configure the Default Application Pool to run on 32-bit, you can change it by opening the Properties window of the application pool and setting the Enable 32-bit Applications property to True. Reporting Services will install on the root web site and will use the Default Application Pool by default. The good thing about this is that you can run both 64-bit and 32-bit web applications within the same server by simply configuring the application pool separately.

After installing SQL Server 2005 Reporting Services, make sure you apply the latest service packs and cumulative updates. A more detailed approach in installing and configuring SQL Server 2005 Reporting Services on a Windows Server 2008 machine can be found on this Microsoft KB article

Next Steps

  • Check your SQL Server 2005 Reporting Services installation and make sure you have the appropriate media for the OS platform. If not, you can always configure IIS to run in 32-bit mode
  • Check out this Microsoft KB article on installing and configuring SQL Server 2005 Reporting Services on a Windows Server 2008 machine
  • Read more Reporting Services tips


Last Update:






About the author
MSSQLTips author Edwin Sarmiento Edwin M Sarmiento is a Microsoft SQL Server MVP and Microsoft Certified Master from Ottawa, Canada specializing in high availability, disaster recovery and system infrastructures.

View all my tips


 









Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


Get free SQL tips:

*Enter Code refresh code     



Thursday, March 19, 2015 - 12:17:43 PM - Ricky Back To Top

 

Hi Sir Edwin,

One more question, if we execute the command below.

 cscript.exe adsutil.vbs set W3SVC/AppPools/Enable32BitAppOnWin64 "true"

can we change it back to true if we decide to install 64-bit SQL Server Reporting Service?

 

Thank you.

 

Best Regards,

Ricky Valencia


Thursday, March 19, 2015 - 12:03:06 AM - Ricky Back To Top

HI Sir Edwin,

 

I don’t see error from Error logs pertaining to Web Server URL inaccessibility.

 

The Report Server Virtual Directory is ReportServer$i03. The Report Manager Virtual Directory is Reports$i03.

 

I tried the default website format below but unable to access.

 

http://<ServerName>.<DomainName>/ReportServer$i03

 

 

http://<ServerName>.<DomainName>//Reports$i03


Wednesday, March 18, 2015 - 10:32:18 AM - bass_player Back To Top

Hi Ricky,

Can you take a look at the Reporting Services error log to see more details about why you cannot access the web service URL? Also, I would strongly recommend upgrading to at least SQL Server 2008 because SQL Server 2005 is already out of mainstream support as per this reference


Wednesday, March 18, 2015 - 12:40:43 AM - Ricky Back To Top

HI Sir Edwin,

 

I installed a 32-bit SQL Sever DB engine and SSRS 2005 in a Windows 64-bit server. It was successfully installed however, I could not access the Web Service URL. Do you have any tips regarding this issue?

 

Thank you.

 

Best Regards,

Ricky


Thursday, June 06, 2013 - 1:01:18 AM - Elvi Back To Top

I use all the time the same iso-file; so I wait if he come again to me ( I have installed from that file )


Wednesday, June 05, 2013 - 9:23:11 AM - bass_player Back To Top

If he is using the same SQL Server 2008 R2 installation media, it should only be either 32-bit or 64-bit. 


Wednesday, June 05, 2013 - 1:38:18 AM - Elvi Back To Top

Hi bass_player,  no I don't have but my customer said to me: install SSRS 32 bit ( maybe he is 'wrong' ?)


Tuesday, June 04, 2013 - 10:24:10 AM - bass_player Back To Top

Hi Elvi,

I don't quite understand how you can come up wit a SQL Server 2008 R2 64-bit and have SSRS in 32-bit. Are you using two different installation media?

 


Tuesday, June 04, 2013 - 8:02:53 AM - Elvi Back To Top

Hi, how does it work for SQL 2008 R2 sp2 with 64 bit and SSRS 32 bit ?  I'm not familiar with IIS and so on :-(

Elvi


Wednesday, May 22, 2013 - 2:21:34 PM - Jay Back To Top
This was a great help in getting SS 2205 installed on a 2008R2 server. Thanks.

Wednesday, March 30, 2011 - 1:17:48 AM - emubd Back To Top

ya it si a nice solution.i like this.but i have gotten a bettre ***ion in other site.this site below

In my workstation I have used 32bit PC. There is no problem every this is working nice. But an unexpected situation arise recently when I try to deploy my application in to a 64 bit windows server. I never face this problem before. ....more

http://aspboss.blogspot.com/


Learn more about SQL Server tools