Download and Install SQL Server 2014 Express Edition

In this article I will explain how to install express edition of SQL Server 2014.

Step 1: Download SQL Server 2014 Express from following here

You need to login to your Microsoft account to download this.

After logging in, fill personal information, select software version i.e., SQL Server 2014 Express 32 Bit or SQL Server 2014 Express 64 Bit, select language, select country/location and click on Continue to download SQL Server 2014 Express Edition SQLEXPR_x64_ENU.exe (for 64 bit)

Step 2: Double click on the downloaded file SQLEXPR_x64_ENU.exe to extract installation files in a folder. After extracting the file and open SETUP.EXE

SQLEXPR_x64_ENU_2014-07-13_23-36-13Step 3: Click on “New SQL stand-alone installation or features to an existing installation”

Greenshot_2014-07-13_23-42-13Step 4: Accept the license terms and click on Next. You can optionally turn error reporting by checking second CheckBox

2014-07-13_23-42-55Step 5: Check “Use Microsoft Update to check for updates (recommended)” if you have internet connection to download updates and click on Next

2014-07-13_23-44-14Step 6: Click on Next

2014-07-13_23-45-07Step 7: Click on “Select All” to select all the features and click on Next

2014-07-13_23-46-44Step 8: Click on “Named Instance” radio button and give a name for the SQL Server instance like “SQLExpress2014” if you have multiple instances of SQL Server installed. This instance will be accessible using localhostSQLExpress2014. You can select Default instance if you do not have any SQL Server instances installed. Then it will be accessed using only localhost

Greenshot_2014-07-13_23-48-19Step 9: Click on Collation tab if you want to customize collation. Then click on Next

2014-07-13_23-49-41Step 10: Click on “Mixed Mode (SQL Server authentication and Windows authentication)” and enter new password for the “sa” account. Then click on “Add Current User” and click on Next

Greenshot_2014-07-13_23-50-09Step 11: Click on Close to complete the installation

Greenshot_2014-07-13_23-53-36We have installed SQL Server 2014 Express but to run any queries we need to install SQL Server Management Studio (SSMS)

To install SSMS you need to select SQL Server 2014 Management Studio Express 64 Bit or 32 bit in Step 1 above. It will download SQLManagementStudio_x64_ENU.exe. Open it to extract inside a folder. Then run Setup.exe from the extracted folder, select “New SQL stand-alone installation or features to an existing installation” and follow the instructions.

Leave a Reply

Your email address will not be published. Required fields are marked *