Skip to main content
Noble Desktop/2 min read

How to Install SQL Server Express

SQL Server Express Setup

1

Download from Microsoft

Go to the SQL Server Express download page, select language, click Download.

2

Pick 32-bit or 64-bit

Check Control Panel → System for your OS architecture.

3

Run Installer

Choose 'New SQL Server stand-alone installation', accept terms, click through Feature Selection.

4

Configure & Verify

Default Instance, Windows authentication mode, Add Current User. Open SQL Server 2014 Management Studio to verify.

Master SQL at Noble Desktop

Noble Desktop's SQL Bootcamp covers queries, joins, aggregations, and the full SQL toolkit data analysts use every day.

Learn how to install SQL Server Express on your computer with this step-by-step guide with pictures.

Step-by-Step Setup Instructions:

1. Go to the SQL Server Express download page

2. Select Language and click Download Sql server express install 8

3. Identify whether your operating system is 32-bit or 64-bit

  1. Click the Windows key + Pause/Break key and it will show you your system info.
  2. Or go to Control Panel = > System and Security => System.

Or 64 bit OS

4. From the list, scroll down and select one of the options listed below, based on your Operating System, and click Next

  1. For 32-bit—ExpressAndTools 32BIT\SQLEXPRWT_x86_ENU.exe (File Size: 840.8MB)
  2. For 64-bit—ExpressAndTools 64BIT\SQLEXPRWT_x64_ENU.exe (File Size: 833.2MB)

5. Run the downloaded file and allow the app to make changes to your computer

6. Click Ok and wait for installation files to be extracted Sql server express install 7

7. Select New SQL Server stand-alone installation or add features to an existing installation Sql server express install 2

8. Accept License Terms and click Next

Sql server express install 9

9. Microsoft Update screen, click Next

10. Feature Selection screen, click Select All and then Next Sql server express install 6

11. Instance Configuration Screen, Select Default Instance and click Next

NOTE: If, during your installation you get an error about Microsoft.Net Framework 3.5 missing, please make sure you go to this webpage and download the Framework required for the installation. You can then select "Re-Run" to continue the setup, and restart your computer later.

Sql server express install 3

12. Server Configuration, set Startup Type to Automatic for both services and click Next Sql server express install 5

13. Database Engine Configuration Screen

  • Select Windows authentication mode

  • Click Add Current User and click Next

Sql server express install 4

14. Once done you should receive Succeeded messages and Close installer.

15. You’ve successfully installed SQL Express 2014 on your computer.

16. Please start SQL Server 2014 Management Studio to confirm that it was installed correctly on your computer. Sql server express install 1