SQLServerWiki

“The Only Thing That Is Constant Is Change”

SQL Server 2005 x64 SSRS on a windows server 2008 x64

Posted by database-wiki on March 5, 2011

I recently experience difficulty in configuring Reporting Services on a Windows 2008 Server with SQL Server 2005. I want to share the solution.

Before I get going, I do want to share with you that the systems that this happened on were not standard builds.  The only reason I mentioned this is because I’m not certain of the degree that the operating system configuration varies from the standard build.

I should also add that the hardware is 64-bit, Windows 2008 Server is 64-bit, and SQL Server 2005 is 64-bit.

The application group installed Internet Information Services (IIS) version 7 on the Windows 2008 platform (a prerequisite for Reporting Services).  I verified that IIS was installed by reviewing the settings in the Internet Information Services Manager.

When installing SQL Server 2005, the option button for installing Reporting Services was grey – indicating that it could not be installed.  I also receive the following warning message during the system configuration check of the SQL Server 2005 installation:

Error 1:

ASP.Net Version Registration Requirement (Warning) Messages

Messages

 ASP.Net Version Registration Requirement

Failed to find the ASP.Net Version Registrations with Microsoft Internet Information Services (IIS).

To fix the situation so that Reporting Services can be installed:

1.      Run Server Manager (Start | Administrative Tools | Server Manager).  Click roles, in the left pane.  Right click on Web Server (IIS).

1.      Insure that all items are selected for Common HTTP Features.

2.      Insure that all items are selected for Application Development.

3.      Insure that Windows Authentication and Request Filtering are selected for Security.

4.      Insure that all items are selected for Management Scripts and Tools. (This step will create the AdminScripts folder in C:\inetpubs)

5.      If you added any roles / features, click the next button and then the install button to install the roles / features.  Reboot the server.

After Error 1 you might also encounter Error 2. If yes, continue with the following.

Error 2:

 ASP.Net Version Registration Requirement (Warning)

Messages

ASP.Net Version Registration Requirement

32-bit ASP.Net is Registered. Required 64-bit ASP.Net to install Microsoft Reporting Services 2005(32-bit).

6.      Open a DOS Prompt (Click Start, click Run, type cmd, and then click OK).

7.      Type the following command to disable the 32-bit mode:

cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 0

8.      Determine the latest version of ASP.NET 2.0.XXX installed on your system (look in the C:\windows\system32\Microsoft.NET\Framework64 folder).

9.      Type the following command to uninstall the current version of ASP.NET and install the most recent version of ASP.NET 2.0 and to install the script maps at the IIS root and under:

%SYSTEMROOT%\Microsoft.NET\Framework64\v2.0.xxx  (replace x’s with highest version)

aspnet_regiis –ua   (uninstalls)
aspnet_regiis –I  (installs)

10.     Open IIS Manager (Start -> Administrative ->Tools Internet Information services (IIS) Manager).   Expand the server on the left pane.  Click on Application Pools.

11.     On the middle panel, select “Classic .NET AppPool”.  On the right pane under Actions click on Set Application Pool Defaults.  In Application Pool Defaults window under General click on Enable 32-Bit Applications.  Set this option to False.

12.     Once again on the middle panel, select “DefaultAppPool”.  On the right pane under Actions click on Set Application Pool Defaults.  In Application Pool Defaults window under General click on Enable 32-Bit Applications.  Set this option to False.

13.     Reset IIS from the command prompt (Start>Run>Cmd) by issuing the command: IISRESET

14.     Restart the installation of SQL Server 2005 Reporting Services.

Error 3:

Even if everything is correctly set. Like me, you will end up at a point where no warning is reported by SQL Server 2005 x64 setup and reporting services grayed out in the selection screen.

15. Follow http://technet.microsoft.com/en-us/library/bb839480(SQL.90).aspx and make sure everything is set and reboot the box and continue the setup.

4 Responses to “SQL Server 2005 x64 SSRS on a windows server 2008 x64”

  1. Hi, this is a comment.
    To delete a comment, just log in, and view the posts’ comments, there you will have the option to edit or delete them.

  2. Hi it didn´t work well until I write in step 11 and 12 instead of false I select True and it runs well

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: