Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


How to install sql server express

Posted on 2014-12-09
Medium Priority
Last Modified: 2014-12-09
I have no experience with SQL Server.
I want Microsoft SQL Server 2012 Express installed on my laptop.
The reason is that I want to upgrade an MS Access database to SQL Server and run it on my laptop.
But first I think I must know what is already installed on my laptop.

Can you identify from the pics below?
What more information do you need?
Which advice have you got for me?

under Program Files/Microsoft SQL Server/Program Files (x86) contents/
Question by:Fritz Paul
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

Expert Comment

by:Dilip Patidar
ID: 40488338
Hello Fritz,

As per my understanding you installed the MS SQL server 2012.  For Database management you have to install Management studio.

You can download from Microsoft Website, Please use the below URL to download the MS SQL Studio.

Once you clienk on this URL :

You can see the Download button. Click on it and select the appropriate component you need.

You have to select the SQLManagementStudio_x86_ENU.exe or SQLManagementStudio_x64_ENU.exe. You can select the appropriate version you need.

Please find the attached URL to Installation steps:

Advise : If you don't want to any problem then you can remove the SQL Server from Control Panel. And install the MS SQL 2012 Express from Installation step URL.

Dilip Patel
LVL 52

Expert Comment

by:Vitor Montalvão
ID: 40488341
That's only folders. Doesn't mean that SQL Server is installed even it's a good evidence of that.
Can you post the programs and services snapshot?

Author Comment

by:Fritz Paul
ID: 40488358
I appreciate.
Here is the picture you requested.
Programs and features
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

LVL 52

Expert Comment

by:Vitor Montalvão
ID: 40488364
So, as you can see, MSSQL 2012 Express Edition is already installed since 2014/05/26.

Author Comment

by:Fritz Paul
ID: 40488378
OK Thanks.

Author Comment

by:Fritz Paul
ID: 40488388
When I follow the first url and then on downlaod I arrive on the same url, but with file options like below.
I do not know which to choose to download. I did uninstall the installation that I had, so this will be a clean installation.
I want to use the installation with Microsoft access front end.

Download choices

The installation steps that you refer to are for installation on Windows Server. Is that applicable?
"Please find the attached URL to Installation steps: "
LVL 52

Expert Comment

by:Vitor Montalvão
ID: 40488394
What are you trying to do Paul?
Check the details:
LocalDB (SqlLocalDB)
 •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 (SQLEXPR)
 • Express edition includes the SQL Server database engine only. Best suited to accept remote connections or administer remotely.
Express with Tools (SQLEXPRWT)
 •This package contains everything needed to install and configure SQL Server as a database server including the full version of SQL Server 2012 Management Studio with SP2. Choose either LocalDB or Express depending on your needs above.
SQL Server Management Studio Express (SQLManagementStudio)
 •This does not contain the database, but only the tools to manage SQL Server instances, including LocalDB, SQL Express, SQL Azure, full version of SQL Server 2012 Management Studio with SP2, etc. Use this if you already have the database and only need the management tools.
Express with Advanced Services (SQLEXPRADV)
 •This package contains all the components of SQL Server Express including the full version of SQL Server 2012 Management Studio with SP2. This is a larger download than “with Tools,” as it also includes both Full Text Search and Reporting Services.

Author Comment

by:Fritz Paul
ID: 40488408
Hi Vitor, I don't think you understand how little I know. As I stated in the initial question..

"I have no experience with SQL Server.
I want Microsoft SQL Server 2012 Express installed on my laptop.
The reason is that I want to upgrade an MS Access database to SQL Server and run it on my laptop.
But first I think I must know what is already installed on my laptop."

The last sentence you have already answered. And I have uninstalled the installation that initially existed.
Now I want to decide what to install. I do not understand the choices.

I think I must go ahead with the last option and get going. Then it seems to me I have everything. Do you agree?

I will download SQLEXPRADV_x86_ENU.exe . I have a 64 bit processor, but I suppose for compatibility with other computers the 32 bit is better.
LVL 52

Accepted Solution

Vitor Montalvão earned 2000 total points
ID: 40488485
Well, before you had the LocalDB installed. I suggest that you download and install the Express with Tools (SQLEXPRWT) 64 bits version. The bits are for the machine where you install it not for the clients that will connect.
LVL 85
ID: 40488505
I would agree with Vitor. Install the Express with Tools, 64-bit edition.

If you're going to deploy your application to others, then of course they would need to be able to connect to a SQL Server, so be aware of that. You can always instruct them to install SQL Server Express on their machines first, but then you must create the database for their use.

In other words, moving from straight Access to a hybrid Access-SQL environment is not just a matter of installing SQL Server, if you're going to connect other users to the database.

Author Closing Comment

by:Fritz Paul
ID: 40488609
OK, I am downloading.

Author Comment

by:Fritz Paul
ID: 40488612
Thanks Scott. I realise i am on a steep learning curve and excited about it, especially with support from EE.

Featured Post

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.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

722 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