Problem in x64 SQL Server 2005 setup

Hi,

Trying to install 64-bit SQL Server 2005 RTM on Windows 2003 x64 Server with SP 1. The Reporting services option is not enabled in the installation steps. The installation process gets completed without any errors, but the Reporting Services is not installed.

The server has IIS installed, the .NET framework 2.0 is installed by SQL Server 2005 RTM itself. Am I doing anything wrong.

Can anyone help/suggest ?

Thanks in advance.

On x64 IIS can be configured to run native (64-bit) or WoW64 (32-bit). Check out this topic in Books Online: http://msdn2.microsoft.com/en-us/library/ms143293(en-US,SQL.90).aspx

You'll need to reverse engineer the steps to make sure IIS is configured to run native - provided you're installing the x64 version of SQL Server. If you're installing the 32-bit version of SQL Server on an x64 machine you'll want to follow this article as is.

Cheers,
Dan

|||

Thanks for response. I am installing x64 SQL 2005 RTM on x64 Windows 2003. The IIS settings are exactly the same, what has been described in the article above.

The problem is I am not able to install Reporting Services 2005. The article describes about the problem for not being able to run it. I wonder the scenarios are different ?

I forgot to mention in my question first time, that the x64 Windows 2003, where I am trying to install x64 SQL 2005 RTM does have SQL 2000 installed (32-bit). I doubt this could be the problem ? Not sure.

Thanks in advance.

|||

At the beginning of setup we run a configuration checker that checks the IIS configuration. If there is a problem with the IIS configuration you'll get a red circle with an X through it for the IIS entry. In addition, you won't be able to select Reporting Services from the feature selection dialog. Can you rerun setup and see if you get an error for IIS in the configuration checker. If you do post the error you get and we can continue trouble shooting - if I remember correctly there are a couple of IIS checks in the configuration checker.

BTW: Having SQL2K installed to WOW64 shouldn't have any impact on this.

Dan

|||

Hi Dan,

I am having the same problem. I want to install SQL 2005 Std x64 on Windows 2003Std x64.

In sql installation wizard everything is great (inlcuding IIS). Only Reporting Servicing has this warning, with the message "

Looking on where the files will go I see "C:\Program files (x86)". I have the impression that entire SQL (database, olap, not just RS) is trying to install with 32bit version, not x64. Do you know why?

How can I be sure what SQL version will be installed?

I will appreciate and help,

Thanks,

Dan

P.S. This is the report from the System Configuration Check, in SQL install wizard.

System Configuration Check

- WMI Service Requirement (Success)
Messages
* WMI Service Requirement
* Check Passed

- MSXML Requirement (Success)
Messages
* MSXML Requirement
* Check Passed

- Operating System Minimum Level Requirement (Success)
Messages
* Operating System Minimum Level Requirement
* Check Passed

- Operating System Service Pack Level Requirement. (Success)
Messages
* Operating System Service Pack Level Requirement.
* Check Passed

- SQL Server Edition Operating System Compatibility (Success)
Messages
* SQL Server Edition Operating System Compatibility
* Check Passed

- Minimum Hardware Requirement (Success)
Messages
* Minimum Hardware Requirement
* Check Passed

- IIS Feature Requirement (Success)
Messages
* IIS Feature Requirement
* Check Passed

- Pending Reboot Requirement (Success)
Messages
* Pending Reboot Requirement
* Check Passed

- Performance Monitor Counter Requirement (Success)
Messages
* Performance Monitor Counter Requirement
* Check Passed

- Default Installation Path Permission Requirement (Success)
Messages
* Default Installation Path Permission Requirement
* Check Passed

- Internet Explorer Requirement (Success)
Messages
* Internet Explorer Requirement
* Check Passed

- COM Plus Catalog Requirement (Success)
Messages
* COM Plus Catalog Requirement
* Check Passed

- ASP.Net Version Registration Requirement (Warning)
Messages
* ASP.Net Version Registration Requirement
* 64-bit ASP.Net is Registered. Required 32-bit ASP.Net to install Microsoft Reporting Services 2005(32-bit).

- Minimum MDAC Version Requirement (Success)
Messages
* Minimum MDAC Version Requirement
* Check Passed