Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Installing 64-bit SQL2005 Standard Expand / Collapse
Author
Message
Posted Thursday, October 29, 2009 8:50 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 10:48 PM
Points: 205, Visits: 1,341
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
Post #810832
Posted Thursday, October 29, 2009 8:58 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Sunday, April 13, 2014 12:23 PM
Points: 3,433, Visits: 14,411
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
Post #810841
Posted Thursday, October 29, 2009 9:22 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:24 AM
Points: 32,781, Visits: 14,942
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
Post #810882
Posted Thursday, October 29, 2009 10:53 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 10:48 PM
Points: 205, Visits: 1,341
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?
Post #810998
Posted Thursday, October 29, 2009 11:04 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Sunday, April 13, 2014 12:23 PM
Points: 3,433, Visits: 14,411

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
Post #811012
Posted Friday, October 30, 2009 4:28 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 10:48 PM
Points: 205, Visits: 1,341
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

Post #811916
Posted Friday, October 30, 2009 4:45 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Sunday, April 13, 2014 12:23 PM
Points: 3,433, Visits: 14,411
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
Post #811918
Posted Friday, October 30, 2009 5:03 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 10:48 PM
Points: 205, Visits: 1,341
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!
Post #811924
Posted Friday, October 30, 2009 5:18 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 11:17 AM
Points: 4,379, Visits: 9,470
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 opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #811928
Posted Wednesday, September 18, 2013 2:34 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 07, 2014 1:15 PM
Points: 4, Visits: 35
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

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.
Post #1496136
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse