Installing 32 Bit Version onto 64 Bit OS

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Installing 32 Bit Version onto 64 Bit OS

Author

Topic

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2011-06-13 : 16:06:59

Hi everyone,

I'm installing 2008 R2 32 bit edition onto a Windows Server 2003 64-bit server.

All the Installation Rules passed, but the "64 bit Operating System" shows a status of "Not Applicable". Same for 64-bit Processor.

And on the Installation Center form, in "Options" it shows that x64 is selected. I would expect to see x86 because I'm installing the 32 bit version of SQL.

This part of the 2008 installation has always been a bit confusing to me.

We purchased the 32 bit version and that's what we downloaded.

Is it alright that the "Options" shows x64?

Thanks, John

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-06-13 : 16:10:50

The SQL Server license is not specific to a processor architecture (not to my knowledge anyway) so you should be allowed to install the x64 version.

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2011-06-14 : 15:40:16

Thanks robvolk. It seems that SQL Server, in its' wisdom, automatically chose x64. After installing the instance IS 64 bit which is what I wanted.

John

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2011-06-14 : 16:17:43

I was about to ask why you would even want to install the 32-bit version on a 64-bit platform. There are really only a couple of issues where this is something you need to do. Namely, the x64 drivers are not available for linked servers or you have extended procedures that cannot be re-written using CLR or recompiled for x64.

Jeff

Bob1337
Starting Member

2 Posts

Posted - 2011-07-31 : 22:31:41

I have installed windows 2008 64-bit on my computer
Motherboard: MSI p67s-c43
CPU: i5-2500k
HDD: WD blue caviar 1To
RAM: 8Go (samsung)

Everything is really slow, It took me more than one hour to install active directory.
I have patched SP1 to solve the sandybridge problem.

But when I wanted to install SQL2008 R2,
it shows 64 bit Operating System "not applicable" and 64-bit Processor "not applicable"

Shouldn't it show "passed" instead of "not applicable" ?
I'm not in 64Bit? My processor should support 64Bit. I don't know what to think.

Bob1337
Starting Member

2 Posts

Posted - 2011-08-03 : 05:42:34

Ok this "not applicable" thing is a false alert.

Refer to here : http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/f5d2ba98-09e4-41aa-98a3-fd4ff53582cb/
“The description of the rule is

64-bit processor Rule: Checks whether Setup is running in a 64-bit process on a computer that is running a 64-bit operating system. This is required for installing SQL Server PowerPivot for SharePoint64-bit operating system.

Rule: Checks for the Windows Server 2008 or later operating system. This operating system is required for installing SQL Server PowerPivot for SharePoint.

Since you are installing Database Engine and Management studio this rule is not applicable as per the rule description.”

But still I don't know why, it is so slow :(

EDIT: (Solution) I have formatted and re-installed win 2008. And now no problem. I have no clue about what was the problem.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources