SQL 2005 SE 64 bit installation on Windows 2003 2 SE x64 platform

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.

more ▼

asked Jan 28, 2010 at 07:19 AM in Default

avatar image

13 1 1 3

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

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'.

more ▼

answered Jan 28, 2010 at 10:11 AM

avatar image

Kev Riley ♦♦
66.8k 48 65 81

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Jan 28, 2010 at 07:27 AM

avatar image

1.7k 4 6 10

This was always my gut feeling. Our Technical Support people download images of disks direct from Microsoft. Is there any way I can prove to them that this is the 32-bit version?

Jan 28, 2010 at 07:33 AM Stuart

Yes, for sure, I just cant tell you exactly how from the top of my mind. I suppose as Kev says below should work, or otherwise look up the sqlservr.exe binary if it is accessible directly on the cd/image

Jan 28, 2010 at 10:14 AM Steinar
(comments are locked)
10|1200 characters needed characters left

Hi Stuart,

I just checked on MSDN website for you, they are completely difference file name. You will get like this if your Tech Support Download from Microsoft.




I hope it helps.

more ▼

answered Jan 29, 2010 at 07:45 AM

avatar image

1.6k 55 59 62

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 28, 2010 at 07:19 AM

Seen: 3319 times

Last Updated: Jan 28, 2010 at 10:14 AM

Copyright 2018 Redgate Software. Privacy Policy