I am attempting to install SQL Server 2005 SE 64 bit on to a Windows 2003 2 SE x64 platform but at the end of the process I end up with the 32 bit version - 9.00.1399.06 (Intel x86).
I have uninstalled and reinstalled a number of times to ensure I am not missing anything out but to no avail.
I do get a warning from the System Configuration Check on the ASP.Net Version Registration Requirement action stating "64-bit ASP .Net is Registered. Required 32-bit ASP .Net to install Microsoft Reporting Services 2005(32-bit)" However I only want the basic Database Services on this server so I have not selected to install Reporting Services. I have tried the Enable32bitAppOnWin64 switching just to see if it would make any difference but it all that happened was I did not get the warning any more. The 32 bit version of Database Services was still installed.
I am using a copy of the two SQL 2005 installation CDs on my C drive (Split into two directories (Servers and Tools) in one parent directory). These were set up by our Technical Support so I have not seen the original disks.
Looking in the setup sub directories there seem to be plenty of %_64_msi files which would indicate to me I do have the correct 64 bit installation disk copies.
I assume somewhere along the installation process it decides whether to install the 32 or 64 bit version. I have not seen this anywhere as a manual option for me to select. What am I doing wrong ?
Any help would be appreciated as I have not been able to find any useful links on the internet over the past few days.
Answer by Kev Riley ·
To see what version you have, if you find the setup.exe in the 'servers' directory, right-click and choose 'properties', then on the version tab, what do you see as the value for comments or platform?
I have checked on my developer edition dvd, and the x86 version states 'NT INTEL X86', whereas the x64 version states 'NT AMD64'.
Answer by Steinar ·
In SQL 2005 64 bit and 32 bit are on different media. So if you actually have 64 bit OS and 64 bit SQL Server 2005 media, you cannot (in my understanding) get a 32 bit installation. It is just not possible. Can you recheck the media you are installing from?
If it si SQL 2008, then there are an option in the fists screen of the install, as it is the same media for 64 and 32 bit.