asked
SQL 2008 R2 installation error
hi. I've got a problem on installation for a week. I am trying to install SQL Server 2008 R2. But the setup fails each time stating the error: "This SQL Server Setup is not supported on a x86 system. To continue, run the SQL Server Setup media that matches your system." Others told me that the software can fit both x86 & x64. my PC is new(system: win7 Professional SP1)and I haven't installed any SQL versions successful before. This morning, I downloaded SQL 2012 SP1 from Microsoft official website, but I met the same problem. What and how can I do now? ![alt text][1] Any help would be highly appreciated. [1]: /storage/temp/1281-qq截图20131230152224.png
Firstly, I really want to thank you for your help! And Yes, it's a 32-bit computer. I followed your advice and clicked the LP.exe file in the x86 directory(SQL Server 2008 R2). However, it didn't work. Nothing about installation appeared. Now I am trying to install SQL Server 2012 in the same way. I find that in the directory: SQL Server 2012 \ x86 \ Setup \ x86 \ , there is a file called " SQL_BOL_Components.msi " which seems like a program package, a software installation package. Could it get installation going? (Actually I would like to install SQL Server 2008 rather than 2012 because I bought the book about 2008 version. But if the 2008 version could not be installed on my PC these days, 2012 is OK. ) Thank you for your help again. :)
The BOL component are for Books Online. That program won't install SQL Server. Although SQL Server will run on both x86 and x64, they do have some installation ISOs that are specific to x86 or x64. It sounds like you have a 64-bit only installation ISO. Did you get it from MSDN? If so, log back in to MSDN subscriber downloads and look for "SQL Server 2012 Enterprise Edition with Service Pack 1 (x86) - DVD (English)" which will install SQL Server on a 32-bit computer. If it was an evaluation copy of SQL Server, you can go back to the download site and select the 32-bit download.
YOu are trying to install sql server 64 bit on a 32 bit computer.which is not possible
I agree with Ramesh. To find out the windows version(32 bit or 64 bit), please follow the below as per the OS. **Microsoft Windows XP Professional** **Method 1** 1. Click Start, click Run, type sysdm.cpl, and then click OK. 2. Click the General tab. The operating system appears as follows:• For a 64-bit version operating system: Microsoft Windows XP Professional x64 Edition Version < Year> appears under System. • For a 32-bit version operating system: Microsoft Windows XP Professional Version< Year> appears under System. Note is a placeholder for a year. **Method 2** 1. Click Start, click Run, type winmsd.exe, and then click OK. 2. In the details pane, locate Processor under Item. Note the value. • If the value that corresponds to Processor starts with x86, the computer is running a 32-bit version of the Windows operating system. • If the value that corresponds to Processor starts with ia64 or AMD64, the computer is running a 64-bit version of the Windows operating system. **Microsoft Windows Server 2003** **Method 1** 1. Click Start, click Run, type sysdm.cpl, and then click OK. 2. Click the General tab. The operating system appears as follows:• For a 64-bit version operating system: Microsoft Windows Server 2003 Enterprise x64 Edition appears under System. • For a 32-bit version operating system: Microsoft Windows Server 2003 Enterprise Edition appears under System. **Method 2** 1. Click Start, click Run, type winmsd.exe, and then click OK. 2. In the details pane, locate Processor under Item. Note the value. • If the value that corresponds to Processor starts with x86, the computer is running a 32-bit version of the Windows operating system. • If the value that corresponds to Processor starts with EM64T or ia64, the computer is running a 64-bit version of the Windows operating system. **Note:** - Intel Itanium-based computers can only run 64-bit versions of Windows. Intel Itanium-based computers cannot run a 32-bit Windows operating system. Currently, 64-bit versions of Windows only run on Itanium-based computers and AMD64-based computers.
SQL Server 2008 R2 Enterprise is not supported on WIN 7 PRO... but your issue does seem that you have the wrong binaries. As everyone else has pointed out - get the 32 bit installation files. Check [here][1] for requirements. [1]:
http://msdn.microsoft.com/en-us/library/ms143506(v=sql.105).aspx
18 People are following this question.
