In our next lessons, we will create databases and tables in MSSQL. WE will insert data in tables and will retrieve data from tables. Therefore it is important to learn ‘How to install SQL EXPRESS’ as well as ‘SQL SERVER MANAGEMNT STUDIO’ on our PC to get our goal. So let’s start to install SQL Express first. SQL Management Studio is also available in the following two flours:

• SQL Management Studio x86 for 32bits Operating System
• SQL Management Studio x64 for 64bits Operating system

So first of all you should check your operating system to decide which one will be suitable for you. For this purpose right click on ‘This PC / My Computer’ and choose the Properties as shown in the following image.

In the device specifications, check your system type as mine is 64bit operating system that is clear in the below picture. So I will install the x64bit SQL Express if yours is 32bit, then you should install x86 version. The installation process and steps for both are the same.

Depending upon your operating system, you should download your required product from Microsoft official site or you can also download your product type from the following links.

1. Download SQL MANAGEMENT STUDIO x64bit
2. Download SQL MANAGEMENT STUDIO x86bit

Save the download file in your favorite folder. Now double click your downloaded file to start extraction and installation as you see in the picture below.

In my case, as I have a 64bit operating system so i will double click the x64bit management studio. Its files extraction will be started as shown below.

When the extraction of files completes, you will see the following dialog box, Click on the New SQL Server Stand-alone installation or add features to an existing installtion

In the next dialog box please give a tick mark to Include SQL Server Products updates
Click Next again on the next dialog box that pops up.

Now the most important dialog box will pop up. Select the 2nd option that is Add features to an existing instance of SQL Server 2012 So it will add features to the already installed SQL Express and click the Next
On the Next dialog box click Select All button to select all the features as show in the figure below.
On the Next dialog box click Next button to continue

The Installation progess dialog box will pop up where you will see that files are being installed.
That's the last of the installation, Click the Close button to finish.

Now click the Start button of your windows and type SQl Management in the serach box. Click on the SQL Server Management Studio to start the application.

In the Server name it is better to type .\SQLEXPRESS instead of your computer name. Click the Connect button
The Object Explorer dialog box will pop up. So this was all about the SQl server management studio. Next we will create database and tables in this by VB.Net Application.

If the above Blog is helpfull for you, then please Subscribe our Youtube Channel

In the next Lesson we will take some steps to configure SQL Configuration Manager