Solved

Having trouble installing SQL Server 2012 Express on Windows 7?

Posted on 2014-07-30
7
1,038 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
  • 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 to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
mp4 file audio extraction 16 115
Batch convert .doc to .docx 13 113
Magic Software info 18 105
Free software for pdf to word conversion 4 37
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
The viewer will learn how to set up a document for the web and print and the recommended PPI for printing.
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

743 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now