Thursday, April 6, 2017

Enable SQL Authentication in SQL Server 2014 Express






Step by step Allow remote connections to SQL Server Express





How to Automate SQL Server Express backups

This video tutorial is created on SQL Server 2012 but it supports most of the MS SQL versions and editions.

Tested on the following:

SQL Server  2014 Express edition 
SQL Server 2016 Express edition 



Add new instances of SQL Server 2012 Express






Step by step how to Install SQL Server 2016 Express and SQL Server Management Studio 2016 Express





Step by step How to Install SQL Server 2014 Express and SQL Server Management Studio 2014 Express

In this tutorial you are going to learn how to install  Install SQL Server 2014 Express and SQL Server Management Studio 2014 Express:

Step 1:- Download SQL server 2014 Express database engine and management Studio from the following link given below.

click here to download
(Image 1)

When you go to this link and click on download you will see multiple files are available for download.

(Image 2)


We're going to select the following two files. 

1.Express 64BIT\SQLEXPR_x64_ENU.exe
2.MgmtStudio 64BIT\SQLManagementStudio_x64_ENU.exe

Then Click Next 
This will start the downloading process.









Step by step how Install SQL Server 2012 Express and SQL Server Management Studio 2012 Express

Download SQL Server Express and Management Studio from the following link:


https://www.microsoft.com/en-in/download/details.aspx?id=42299