?
Solved

Having trouble installing SQL Server 2012 Express on Windows 7?

Posted on 2014-07-30
7
Medium Priority
?
1,119 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

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 2000 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

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

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

Healthcare organizations in the United States must adhere to the guidance of both the HIPAA (Health Insurance Portability and Accountability Act) and HITECH (Health Information Technology for Economic and Clinical Health Act) for securing and protec…
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

764 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