32 bit 2005 SQL server and 64 bit 2008 Server

Question

32 bit 2005 SQL server and 64 bit 2008 Server

coenzyme77

SSCommitted

Points: 1669
More actions
May 6, 2009 at 8:45 am

#137350

Hi everyone. Got a 64 bit 2008 server and want to install a 32 bit 2005 instance. Don't have the 64 bit SQL media on site. Has anyone successfully installed an instance under these conditions or is the System Configuration Checker (SCC) going to error and block the install. Thanks again for everyone being there to help.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 1

Ed Wyant (5/6/2009)
Hi everyone. Got a 64 bit 2008 server and want to install a 32 bit 2005 instance. Don't have the 64 bit SQL media on site. Has anyone successfully installed an instance under these conditions or is the System Configuration Checker (SCC) going to error and block the install. Thanks again for everyone being there to help.

Yes - you can install the 32bit version on a 64bit host, but I really have to ask why you would want to do that. Your applications will not know the difference if you install the 64bit version.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

coenzyme77 SSCommitted Points: 1669 More actions · Answer 2

Thanks Jeffrey. Are you saying that the 32 bit SQL version ("...your applications..." ) can access the same memory amount as the 64 bit version, and also have similar performance in reads, writes, scans and other sql operations?

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 3

No - the 32bit version of SQL has the same limitations that it would have on a 32bit OS. There is no reason to install the 32bit version on a 64bit OS, but it does work.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

coenzyme77 SSCommitted Points: 1669 More actions · Answer 4

Thanks for the followup Jeffrey. Per my previous, I can't install the SQL 64 'cause I don't have the media on site, and I'm in a rush... " there's frequently time to do it twice or more, but not sufficient time to do it right once the first time".