Install SQL Server Management Studio Step By Step Process

  Total Views : 625
  Comments : 1
 
  Keywords : Step by step to installing sql server management studio, How to install sql server management studio 2008 r2, Sql server management studio step by step installation process

Here we will learn step by step process to install sql server management studio in our system in 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 setup file like as shown below

 

open sql server installation setup file in folder

 

Whenever you click on setup file it will show 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 require Microsoft .Net Framework and an updated windows installer that’s the reason it will show 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 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 install button 

 

After completion of setup rules checking in sql server installation

 

In next screen it will ask product key 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 Next button

 

Accept terms and conditions to install sql server

 

Now select SQL Server Feature Installation like as shown below and click 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 required tests once everything finished click 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 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 allows 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 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 installation configuration rules window it will do some tests once everything 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 install button like as shown below

 

Ready to Install SQL Server in System

 

In 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 message like as shown below

 

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

 

Now go to 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 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

 Comments (1)

  • dileep tutlane registered profile image
     
    dileep   Reply

    please send the link to download

     Feb 18, 2016

Leave a comment

  • Default Tutlane User