Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to install SQL server 2008 r2 on a windows server 2008 64x inside a VM . but I currently have three different files inside the SQL server 2008 ISO image the files ends with IA64 , x64 , x86 ; so what are the differences between the three files and which one I should chose baring in mind that I am installing the SQL Server to be used with SharePoint 2013. BR

share|improve this question

closed as off topic by Chris S May 10 '13 at 15:30

Questions on Server Fault are expected to relate to server, networking, or related infrastructure administration within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

Are you going for some kind of record for the most number of amateur, haven't-even-googled-it, basic and inappropriate questions a user can ask on their first day or are you just trolling us?

IA64 is for Itanium CPUs, x64 is for 64-bit x86 CPUs and x86 is for 32-bit x86 CPUs.

share|improve this answer
I wish I could just post lol. – NickW May 10 '13 at 15:32
the minimum character limit was designed to stop single word answers of "dick', but 'lol' works too ;) – Chopper3 May 10 '13 at 15:34

The difference is which architecture SQL Server expects to run on:

  • x86 = 32-bit or 64-bit Intel/AMD CPUs w/ 32-bit or 64-bit Windows OS
  • x64 = 64-bit Intel/AMD CPUs w/ 64-bit Windows OS
  • IA64 = Intel Itanium CPUs running IA64 Windows OS

You can discount IA64 -- if you were using it, you'd know it. So that leaves x64 vs x86, which is a tradeoff you need to balance for yourself. In most cases, if you're running Windows x64, you'll want to use SQL Server x64 too.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.