SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Installing 64-bit SQL2005 Standard


Installing 64-bit SQL2005 Standard

Author
Message
rew-370421
rew-370421
Old Hand
Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)

Group: General Forum Members
Points: 356 Visits: 1382
I'm new to SQL2005 64-bit (and to the W2K3 64-bit O/S too). I'm trying something new!

Does the 32-bit & 64-bit versions of SQL2005 come on the same CD?

When a W2K3 64-bit O/S Server is built and I begin the SQL2005 installation, does SQL DETECT that my O/S is 64-bit and install the 64-bit version of SQL2005, or do I run a different 64-bit version installer?

...thanks
Gift Peddie
Gift Peddie
SSCertifiable
SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)

Group: General Forum Members
Points: 6470 Visits: 14456
rew-370421 (10/29/2009)
I'm new to SQL2005 64-bit (and to the W2K3 64-bit O/S too). I'm trying something new!

Does the 32-bit & 64-bit versions of SQL2005 come on the same CD?

When a W2K3 64-bit O/S Server is built and I begin the SQL2005 installation, does SQL DETECT that my O/S is 64-bit and install the 64-bit version of SQL2005, or do I run a different 64-bit version installer?

...thanks


I am not sure about retail but the SQL Server 2005 I used from employer's network drive and MSDN are separate builds while the SQL Server 2008 comes in AnyCPU which means the file is huge, the SQL Server 2005 is only 1gig while the SQL Server 2008 is 3gig plus. So check if it says x86_x64_ia64 then it is AnyCPU.

Kind regards,
Gift Peddie
Steve Jones
Steve Jones
SSC Guru
SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)

Group: Administrators
Points: 64737 Visits: 19118
There's no detection I'm aware of. I haven't used real media in years. Always downloaded, and looked x86 or x64 in the file name. Since a x86 will install on 64 bit machines, you want to be careful. My guess is that you want to find the x64 setup files.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
rew-370421
rew-370421
Old Hand
Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)

Group: General Forum Members
Points: 356 Visits: 1382
Hi Steve, I looked through my SQL2K5 software and found no setup executables with x64. I did find a few filenames with x64 on them like: sqlncli_x64.msi and SqlWriter_x64.msi and SqlServer2005_BC_x64.msi

Has no one installed SQL2K5 64-bit and knows how?
Gift Peddie
Gift Peddie
SSCertifiable
SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)

Group: General Forum Members
Points: 6470 Visits: 14456

Has no one installed SQL2K5 64-bit and knows how?


My answer was based on your questions there is no difference when installing SQL Server 2005 either x86 or x64, in 2005 the only thing to look for is make sure all your web use for IIS6 to be x64 or you have to run IIS 6 in x86 mode because you cannot run IIS6 in both x86 and x64 modes. If you are not running SSRS it is simple install if you are running SSRS make sure you add IIS6 and click on details to enable features needed to run Asp.net because SQL Server 2005 installer will disable SSRS if IIS is not running.

Kind regards,
Gift Peddie
rew-370421
rew-370421
Old Hand
Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)

Group: General Forum Members
Points: 356 Visits: 1382
It looks to me like there are 2 separate downloads/CDs etc for 32 Bit & 64 Bit


Microsoft SQL Server Standard Edition 2005 32 Bit CD/DVD 5 Client (Windows)
2 new from $1,800.00


Microsoft SQL Server Standard Edition 2005 64 Bit CD/DVD 1 Processor License (Windows)
2 new from $3,500.00



http://www.amazon.com/s/ref=nb_ss_8_7?url=search-alias%3Dsoftware&field-keywords=sql+server+2005+standard+edition&sprefix=sql+ser
Gift Peddie
Gift Peddie
SSCertifiable
SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)

Group: General Forum Members
Points: 6470 Visits: 14456
rew-370421 (10/30/2009)
It looks to me like there are 2 separate downloads/CDs etc for 32 Bit & 64 Bit


Microsoft SQL Server Standard Edition 2005 32 Bit CD/DVD 5 Client (Windows)
2 new from $1,800.00


Microsoft SQL Server Standard Edition 2005 64 Bit CD/DVD 1 Processor License (Windows)
2 new from $3,500.00



http://www.amazon.com/s/ref=nb_ss_8_7?url=search-alias%3Dsoftware&field-keywords=sql+server+2005+standard+edition&sprefix=sql+ser




That link comes with all platforms including Itanium 64 so you could buy the x64 1 processor license the price is very good make sure it is valid license before your buy.

Kind regards,
Gift Peddie
rew-370421
rew-370421
Old Hand
Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)Old Hand (356 reputation)

Group: General Forum Members
Points: 356 Visits: 1382
Correct. At least now I now that we have to buy separate software because there is one for 32-bit and one for 64-bit!
Jeffrey Williams 3188
Jeffrey Williams 3188
SSCertifiable
SSCertifiable (8K reputation)SSCertifiable (8K reputation)SSCertifiable (8K reputation)SSCertifiable (8K reputation)SSCertifiable (8K reputation)SSCertifiable (8K reputation)SSCertifiable (8K reputation)SSCertifiable (8K reputation)

Group: General Forum Members
Points: 7983 Visits: 9971
rew-370421 (10/30/2009)
Correct. At least now I now that we have to buy separate software because there is one for 32-bit and one for 64-bit!


No - you don't have to buy separate software. The license you purchased is good for either x86 or x64. I am not sure about IA-64...

If you have valid licenses for SQL Server 2005 - but don't have x64 version, you can contact Microsoft to get the x64 version.

Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.

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

willspurgeon
willspurgeon
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 66
rew-370421 (10/29/2009)
Hi Steve, I looked through my SQL2K5 software and found no setup executables with x64. I did find a few filenames with x64 on them like: sqlncli_x64.msi and SqlWriter_x64.msi and SqlServer2005_BC_x64.msi

Has no one installed SQL2K5 64-bit and knows how?


Pardon for resurrecting an old post, maybe it would be better to start a new thread, but anyway...

Based on my same observation that the CD's I have contain x64 versions of some of the executables, I assumed the Install would do some kind of OS detection. However in practice after the install is complete, I find I'm running an "Intel x86" version of SQL on my 64-bit Windows server Sad

For now I'm just turning on AWE and moving on, but is the correct answer "You need to get the x64 CD's from Microsoft"? (or download the x64 zip).

Thanks.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search