Step by Step Installation of MSSQL 2014 Express

In this post we will walk through the process of step by step installation of MSSQL 2014 Express on Windows Server 2012 R2.

As you are of aware of the latest release of MSSQL version 2014, Microsoft has made it publically available on April 1st 2014. MSSQL 2014 Offers new features like In-Memory OLTP which allows you to move the specific database tables to special in-memory structures instead of moving the whole database itself for delivering breakthrough performance. Other enhancement includes integration with Windows Azure for SQL backups, Resource Governor for I/O where we can limit the amount of IOPS etc.

So lets start the MSSQL 2014 installation on Windows Server 2012 R2.

Download Microsoft SQL Server 2014 Express via  http://www.microsoft.com/en-in/download/details.aspx?id=42299&WT.mc_id=rss_alldownloads_devresources

I had downloaded SQLEXPRADV_x86_ENU.exe file since this package contains all the components of SQL Server Express including SQL  Management Studio, Reporting Services etc.

Once downloaded, extract the SQLEXPRADV_x86_ENU.exe file to begin with the installation.

Run the step file and you will be seeing the Installation Wizard.

Choose New SQL Server stand-alone installation or add features to an existing installation.

sql-install1

Accept the License term and click “Next” twice.

sql-install2

In Next option we can select the available features. You can select accordingly or select All in order to install all the component and click Next.

sql-install3

Select whether default or named instance. I have chosen “Default” instance name “MSSQLSERVER” and click Next

sql-install4

Next section is Server Configuration where we can specify the startup time. Click Next.

sql-install5

Next section we will be asked to setup the Database Engine Configuration where we can mention the SQL Authentication methods used.

By default, Windows Authentication mode is enabled. We can setup SQL Authentication in this step. Otherwise we can configure it later. Click Next.

sql-install6

Next one is Reporting Service Configuration. Select “Install and configure option. Click Next which will begins the SQL installation.

sql-install7

A progress bar will be displayed regarding the installation.

sql-install8

You’re done! MSSQL 2014 Express has been installed and you will be seeing the following screen.

sql-install9

Now we login to the Database server using SQL Management Studio for Managing the Databases.

Total
0
Shares
Leave a Reply

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

Related Posts