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

Question

question

Stuart asked Jan 28, '10

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.

sql-server-2005 installation 64-bit windows-2003 setup

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2010-01-28T10:11:37Z

Kev Riley answered Jan 28, '10

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

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2010-01-28T07:27:49Z

Steinar answered Jan 28, '10

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.

2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Stuart commented · Jan 28, 2010 at 07:33 AM

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?

0 ·

Steinar commented · Jan 28, 2010 at 10:14 AM

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

0 ·

Answer 3 · 2010-01-29T07:45:38Z

Leo answered Jan 29, '10

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.

en_sql_2005_std_x86_....iso

(OR)

en_sql_2005_std_x64_....iso

I hope it helps.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question