Solved

Having trouble installing SQL Server 2012 Express on Windows 7?

Posted on 2014-07-30
7
1,089 Views
Last Modified: 2014-08-03
I just installed Windows 7 Home Premium Edition on my laptop which is a 64-bit machine. I downloaded the SQL Server 2012 Express from the MS website. When I went to install it...it told me that it was incompatible with my machine and that I needed to determine if I had a 32-bit or 64-bit machine.

Any ideas on this? Are there different versions of MS SQL depending on hardware?

Thanks!
0
Comment
Question by:BlakeMcKenna
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 9

Expert Comment

by:Tom
ID: 40230415
So have you installed a 32 or 64 bit Windows 7?
Find out by clicking on Start - right click on Computer - select Properties

Make sure you have downloaded the right version of SQL Server
0
 

Author Comment

by:BlakeMcKenna
ID: 40230456
It should be a 64-bit Windows but I will recheck that. I ordered the version from a retailer and it had to be mailed to me. Often times that's a crap shoot!

Would you by chance have the correct link to SQL Server 2012 Express?
0
 
LVL 9

Expert Comment

by:Tom
ID: 40230471
Here it is:
http://www.microsoft.com/en-us/download/details.aspx?id=29062

Make sure you download the version you need, after selecting Language you have several options.
0
How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

 

Author Comment

by:BlakeMcKenna
ID: 40230534
See screenshot. I'm assuming for 64-bit machine, it will be one of the options circled in red.
Screenshot.jpg
0
 
LVL 9

Accepted Solution

by:
Tom earned 500 total points
ID: 40230652
You don't need to assume, follow the instructions from the included picture.
You can have 32 or 64 bit Windows 7 installed on a 64 bit machine.

So if you have installed 32 bit Windows 7, you will need the x86 version of SQL Server
64bit.jpg
0
 
LVL 9

Expert Comment

by:Tom
ID: 40230697
The different versions are:

LocalDB (MSI installer) (LocalDB.msi)
New to the Express family, LocalDB is a lightweight version of Express that has all its programmability features, yet runs in user mode and has a fast, zero-configuration installation and short list of pre-requisites. Use this if you need a simple way to create and work with databases from code. It can be bundled with Application and Database Development tools like Visual Studio and or embedded with an application that needs local databases.

Express (Containing only the database engine) (SQLEXPR_x64_ENU.exe)
The core Express database server. Use this if you need to accept remote connections or administer remotely.
Express with Tools (with LocalDB) Includes the database engine and SQL Server Management Studio Express)
This package contains everything needed to install and configure SQL Server as a database server. Choose either LocalDB or Express depending on your needs above.

SQL Server Management Studio Express (Tools only) (SQLManagementStudio_x64_ENU.exe)
This does not contain the database, but only the tools to manage SQL Server instances, including LocalDB, SQL Express, SQL Azure, etc. Use this if you already have the database and only need the management tools. This package includes LocalDB.

Express with Advanced Services (SQLEXPRADV_x64_ENU.exe)
 (contains the database engine, Express Tools, Reporting Services, and Full Text Search)
This package contains all the components of SQL Express. This is a larger download than “with Tools,” (SQLEXPRWT_x64_ENU.exe) as it also includes both Full Text Search and Reporting Services.

The last one is the full package
0
 

Author Closing Comment

by:BlakeMcKenna
ID: 40237850
Tom, as it turns out, I am running 32-bit Windows 7 instead of 64-bit. I thought that's what I had purchased but as I mentioned, I bought Windows 7 and it was shipped to me. Mis-communication at it's best! Anyway, I installed the 32-bit version and that worked.
Thanks for your help!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Tablet PCs slow responsiveness relative to other local non-tablet PCs. 10 142
PDF edit software 2 62
Cannot install SkypeSetup.exe 4 75
Excel compare strings 6 53
Let’s list some of the technologies that enable smooth teleworking. 
Skype is a P2P (Peer to Peer) instant messaging and VOIP (Voice over IP) service – as well as a whole lot more.
The viewer will learn how to set up a document for the web and print and the recommended PPI for printing.
This video demonstrates how to use each tool, their shortcuts, where and when to use them, and how to use the keyboard to improve workflow.

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question