How to Install SQL Server 2008

CS711 Assignment Solution no1 2019

What is Important???

It is very important to install Microsoft sql server management studio to run sql .If you dont have sql server management studio then you SQL SERVER will not run.

However If you want to run SQL on your computer then what you have to do is to install Microsoft SQL SERVER MANAGEMENT STUDIO then Follow the Link Below….

Install Microsoft SQL SERVER MANAGEMENT STUDIO

How to Install SQL Server 2008:Step 1

  • First we have to Download Microsoft SQL Server 2008 for windows 10
  • What you have to do is to simply write Microsoft SQL Server 2008 Download for Windows 10 on your Internet search engine
  • Then click in the very First link to Download Microsoft SQL Server 2008 .
  • Let see the

    Figure : 1.1

    below to understand it better….

Figure 1.1|How to Install Microsoft SQL SERVER 2008

Figure 1.1|How to Install Microsoft SQL SERVER 2008
Figure 1.1|How to Install Microsoft SQL SERVER 2008

How to Install SQL Server 2008 | Figure 1.2

How to Install Microsoft SQL SERVER 2008 | Figure 1.2
How to Install Microsoft SQL SERVER 2008 | Figure 1.2


More-over If you want to Download Microsoft SQL SERVER 2008 Directly.

You may use the Below Link to download Microsoft SQL SERVER 2008 .

By using the Below link you will able to download Microsoft SQL SERVER 2008 .

Download Microsoft SQL SERVER 2008

Step 2 : How to Install SQL Server2008

When your Download of Microsoft SQL Server 2016 will be completed then you just have to go in your PC Downloads Folder

Double Click => This Pc => Click =>Downloads =>Click on SQL Server 2008 Folder .

Figure 1.3|How to Install Microsoft SQL SERVER2008

Figure 1.3|How to Install Microsoft SQL SERVER 2008
Figure 1.3|How to Install Microsoft SQL SERVER 2008

Now the System will Starts Extracting File to Install Microsoft SQL SERVER2008.

As Shown in the Figure Below

How to Install SQL SERVER2008 | Figure 1.4

How to Install Microsoft SQL SERVER 2008 | Figure 1.4
How to Install Microsoft SQL SERVER 2008 | Figure 1.4

Similarly after Extracting all the Files Now the Installation Process will make itself ready to start the Installation Process of Microsoft Sql Server 2008.

The Figure 1.5 pasted below will illustrate it better

Figure 1.5|How to Install SQL SERVER2008

Figure 1.5|How to Install Microsoft SQL SERVER 2008
Figure 1.5|How to Install Microsoft SQL SERVER 2008

Now a New Wizard of SQL SERVER INSTALLATION CENTER will be open on your Desktop ..

Similarly WHAT you HAVE to do is to Click on New Installation to start the Installation process Of SQL SERVER 2008

Let See the Figure Below

How to Install Microsoft SQL SERVER | Figure 1.6

How to Install Microsoft SQL SERVER 2008 | Figure 1.6
How to Install Microsoft SQL SERVER 2008 | Figure 1.6

Similarly Now the Setup Support Rules wizard Will open and check the upcoming problems after checking the installation process of MIcrosoft SQL SERVER2008 will Starts.

As shown in the figure 1.7 Below

Figure 1.7|How to Install SQL Server2008

Figure 1.7|How to Install Microsoft SQL SERVER 2008
Figure 1.7|How to Install Microsoft SQL SERVER 2008

How to Install Microsoft SQL Server 2008|Step 3

In the third step of the installation process of SQL server 2008 you should simply have to set credentials for the installation of SQL Server 2008.

At this stage the a popup or in other words a Window will Display on your screen which determines you the SQL server will be ready to set its credentials after some time.

You will better understand the process after taking sight on the pictures attached below

After taking some time this installation window shows another window in which you have to agree with the license agreement of vendor or In other Words you have to accept the conditions which are set by the product maker or SQL Server 2016 vendor which is MICROSOFT.

How to Install Microsoft SQL SERVER2008 | Figure 1.8

How to Install Microsoft SQL SERVER 2008 | Figure 1.8
How to Install Microsoft SQL SERVER 2008 | Figure 1.8

However what you have to do now is to click on the CheckBox associated with the License Agreement Acceptance.

As Shown in the Figure 1.9

Figure 1.9|How to Install Microsoft SQL SERVER2008

Figure 1.9|How to Install Microsoft SQL SERVER 2008
Figure 1.9|How to Install Microsoft SQL SERVER 2008

After The License Agreement The Installation Process or In other Words Setup Support File Wizard will be open again and gathers all the required components.

However it will take some time

After that What you Have to Do is to Click on Install Button

How to Install SQL Server2008 | Figure 2.0

How to Install Microsoft SQL SERVER 2008 | Figure 2.0
How to Install Microsoft SQL SERVER 2008 | Figure 2.0

Step 3|How to Install Microsoft SQL Server2008

Now in the Step 3 of Learn How to Install Microsoft SQL Server2008 we will do FEATURE SELECTION after clicking on INSTALL Button.

Just take a look on the picture attached below

Figure 2.1|How to Install Microsoft SQL SERVER2008

Figure 2.1|How to Install Microsoft SQL SERVER 2008
Figure 2.1|How to Install Microsoft SQL SERVER 2008

The installation process of Learn How to Install Microsoft SQL SERVER 2008 show you its Feature Selection Window which provides you many option ..

  • If you want to select some or one or two features of SQL you will checked by Clicking on the CheckBox associated with the feature for feature Selection only those features you want in the installation process of how to Install Microsoft SQL SERVER 2008
  • Similarly If you want to select All features of SQL you will checked all features or click on “Check All” Button in the installation process of how to Install SQL SERVER2008 .
  • If you Did not want to select some or any features of SQL SERVER2008 you will un-checked all those features or simply Click on UN CHECKED Button in the installation process of how to Install Microsoft SQL SERVER2008 .
  • Learn How to Install Recommends you Select All the Features of Microsoft SQL SERVER in the installation process of Microsoft SQL SERVER .
  • As shown in the figure below……..

Installation Steps Microsoft SQL SERVER 2008 | Figure 2.2

How to Install Microsoft SQL SERVER 2008 | Figure 2.2
How to Install Microsoft SQL SERVER 2008 | Figure 2.2

After Clicking on the next button the instance configuration process will be start …

The Instance Configuration Process of the installation process of Microsoft SQL SERVER 2008 deals with two type of instances…..

  1. Default Instance
  2. Named Instance

Default Instance

In This Article Learn How to Install Microsoft SQL SERVER2008 you will also learn or know what is default instance or what is Named instance..

What is the Default Instance in the Installation Process of Microsoft SQL SERVER 2008 ???

Default Instance is the Instance which is made by your system of computer like wise it is the form of server which is made by your system and system also give the name to this server by default …

Named Instance

What is the Named Instance in the Installation Process of Microsoft SQL SERVER 2008 ???

Named Instance is the Instance which is made by you like wise it is the form of server which is made by you and in this type of system you are able to give name to your server what ever you want and also made a password for that specific server …

Learn how to install recommends you to choose default instance instead of Named Instance to get rid of any problem.

The Figure pasted below will make you better under stand..

In the below figure the named instance radio button is on and its give you option to made the name of server whatever you want ..

Figure 2.3|How to Install Microsoft SQL SERVER2008

Figure 2.3|How to Install Microsoft SQL SERVER 2008
Figure 2.3|How to Install Microsoft SQL SERVER 2008

Recommendations……

How to Install Microsoft SQL SERVER2008 | Figure 2.4

How to Install Microsoft SQL SERVER 2008 | Figure 2.4
How to Install Microsoft SQL SERVER 2008 | Figure 2.4

If you want to make your instance with default Setting then simply what you have to do in the installation process of SQL server 2008 you should have to click on the radio button of default instance .

How to Install SQL Server2008 |Step 4

Server Configuration Step

Now its the turn of SYSTEM CONFIGURATION in the installation process of How to Install Microsoft SQL SERVER2008

How ever for this step what you have to do is to do or click on Next Button to continue installation process of Microsoft SQL SERVER 2008

Figure Below Will Elaborate it Better

Figure 2.5|How to Install SQL Server2008

Figure 2.5|How to Install Microsoft SQL SERVER 2008
Figure 2.5|How to Install Microsoft SQL SERVER 2008

After the Server Configuration Step the Next step of the installation Process of Microsoft SQL SERVER 2008 is Database Engine Configuration

Now at this step there are also two steps

  1. Windows Authentication Mode
  2. Mixed Mode

Windows Authentication Mode

In this window No Username and password is required the system wikll set it by default ..

Mixed Mode:

In Mixed mode you have to set Password while you are accessing your database engine..

Lean How to Install will recommends you to choose Windows authentication Mode to get rid or stay away from any error exception or problem.

However the Figure pasted below will illustrate you better

How to Install Microsoft SQLSERVER 2008 | Figure 2.6

How to Install Microsoft SQL SERVER 2008 | Figure 2.6
How to Install Microsoft SQL SERVER 2008 | Figure 2.6

Below is the Figure of Mixed Mode In Which you will set password for your Database Engine.

How Ever take a look on the picture below

Figure 2.7| Install and download SQL SERVER

Figure 2.7|How to Install Microsoft SQL SERVER 2008
Figure 2.7|How to Install Microsoft SQL SERVER 2008

Installation Tutorials of Microsoft SQL SERVER 2008 |Step 5

More Over the Next Step is the Error Reporting Step in which What you have to do is to Click on The Next Button to continue the installation process

As Shown in the Figure 2.8 Below

Figure 2.8|Download Microsoft SQL SERVER 2008

Figure 2.8|How to Install Microsoft SQL SERVER 2008
Figure 2.8|How to Install Microsoft SQL SERVER 2008

How Ever After Clicking on the Next Button The proper Installation of Microsoft SQL SERVER 2008 will starts

As Shown in the Figure 2.9 Below

Installation of Microsoft SQL SERVER 2008 | Figure 2.9

How to Install Microsoft SQL SERVER 2008 | Figure 2.9
How to Install Microsoft SQL SERVER 2008 | Figure 2.9

And At the End when your Installation Process of Microsoft SQL SERVER 2008 Has been Completed you will get the window like the Figure Below ..

Much More the Windows of Completion of How to Install Microsoft SQL SERVER2008 will be shown as the figure shown below

Figure 3.0|How to Download Microsoft SQL SERVER2008

Figure 3.0|How to Install Microsoft SQL SERVER 2008
Figure 3.0|How to Install Microsoft SQL SERVER 2008

Congratulations!!!!! Your Server is installed successfully …

How to Install Sql Server 2012

Step By Step Guide To Install Sql Server 2016

How to Install Sql Server2008

Learn How to Install Sql Server Management Studio 2016

Step By Step tutorial to install Android Studio

How to Install SAP CRYSTAL REPORT

Learn How to Install SAP CRYSTAL REPORT RUN TIME

Step By Step Guide To Install SQL LOCALDB

Author: A.J. Bhatti