SQL Server Management Studio Installation

Here we will learn step by step process to install sql server management studio in our system in a detailed manner.

SQL Server Installation Step By Step Process

Here we will see how to install SQL in our system for that follow below steps. Here we are installing SQL in windows 8.1 OS. 

 

Now go to your SQL Server installation files folder and double click on the setup file like as shown below.

 

open sql server installation setup file in folder

 

Whenever you click on the setup file, it will show the compatibility assistance window just ignore that message and click Run the program without getting help like as shown below.

 

select option to run program without getting help to install sql server

 

To setup SQL Server 2008 R2 it requires Microsoft .Net Framework and an updated windows installer that’s the reason it will show an alert window in that click OK to install required things like as shown below.

 

Need Microsoft .Net Components to install sql server

 

Once that is installed it will show the popup for Windows Update Standalone Installer, click OK button to install Windows Installer like as shown below.

 

Installing required .net components from windows installer

 

Once we finish installation it will ask you to restart the system. Once we restarted now double click on setup button to install SQL Server it will open installation screen like as shown below in that select installation à under that select New installation or add features to an existing application like as shown below.

 

Select new installation or add features to an existing application to install sql server

 

Once click on “New installation or add features to an existing application” it will open another window like as shown below.

 

Setup rules checking result to install sql server

 

Here it will run Setup Support Rules like as shown above once done click OK. Now it will open another window to Setup Support Rules in this window click install button like as shown below.

 

Check Setup Support Files to Install SQL Server

 

Once Setup Support Rules installation finished it will show tested result like as shown below in this if everything fine then click the install button.

 

After completion of setup rules checking in sql server installation

 

In the next screen, it will ask for the product key if you enter your key and click Next button like as shown below.

 

Enter product key to install sql server

 

Now accept the terms and conditions and click the Next button.

 

Accept terms and conditions to install sql server

 

Now select SQL Server Feature Installation like as shown below and click the Next button.

 

Select SQL Server Feature Installation

 

Now click on Select All button to select all features to install and then click Next button like as shown below.

 

Select all features to install sql server

 

It will do the required tests once everything finished, click the Next button like as shown below.

 

Installation rules status to install sql server

 

Now select Default Instance and click Next button like as shown below.

 

Select default instance to install sql server

 

Now it will show required disk space to install all SQL Server features in that click Next like as shown below.

 

Checking disk space requirement to install sql server

 

In the server configuration screen, you need to configure your accounts like as shown below and click Next button.

 

Server configuration for user accounts to install sql server

 

Now in database engine configuration window select Mixed mode authentication (It will allow you to login with windows and SQL authentication) then specify password for your account and also add SQL Server administrator account for that click on Add Current User button to add current user as administrator or click on Add button to add new user and click next like as shown below.

 

Database Configuration Settings to Install SQL Server

 

In Analysis services configuration window specify administrator by Click on Add Current User button or Add button to add a new user as administrator like as shown below.

 

Add current user to install sql server analysis services

 

In reporting services configuration window select Install the native mode default configuration and click Next button like as shown below.

 

select install the native mode default option to install sql server

 

Now in Error Reporting window click Next button like as shown below.

 

allow error reporting to install sql server in system

 

In the installation configuration rules window, it will do some tests once everything is done click Next button like as shown below.

 

Installation Configuration Rules test Results to Install SQL Server

 

Now we are ready to install SQL Server so click on the install button like as shown below.

 

Ready to Install SQL Server in System

 

In the installation progress window, it will show installation progress once done click next button like as shown below.

 

SQL Server Installation in Progress Status

 

Once everything installed correctly it will show a message like as shown below.

 

After successful installation of sql server we will get message lik SQL Server Installation Completed Successfully

 

Now go to the start button of windows and open SQL Server Management Studio 2008 R2 like as shown below.

 

Open sql server management studio in system by searching in system

 

Now enter the server name and click Connect button like as shown below.

 

Enter server name to connect sql server database

 

Now our SQL Server Management studio like as shown below.

 

After connecting server in sql server management studio