Solved

Having trouble installing SQL Server 2012 Express on Windows 7?

Posted on 2014-07-30
7
1,099 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

705 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