How To Install Microsoft Sql Server 2008

In our previous commodity we learned about FileStream in SQL Server. If you wish to become through the article, below is the link for the same.

• Introduction to SQL Server FileStream in 2008

On my machine, I've already installed 3 named instances of SQL 2008 and 2022 and at present I'll be installing default instance of SQL 2008. You can encounter, there's a little difference in installation steps when you do a fresh installation.

Every bit this volition exist my fourth instance, information technology'll not be a fresh installation. Simply no worries, we'll besides see the steps for fresh installation.

Then, I've divided this in 2 sections equally listed beneath.

1. No fresh installation steps
2. Fresh Installation steps

No fresh installation

Step ane: Open explorer and you'll see setup file equally shown below.

Right click on the setup and run it every bit Ambassador.

Step 2: SQL Server Installation Center.

Go to installation department, hither y'all'll find various options to install example, add together new features and upgrade your SQL Server. As nosotros're doing a fresh installation, we'll select start option i.eastward. "New SQL Server stand up-alone installation".

Step iii: Setup Support Rules

Hither setup will perform a check to ensure whether y'all can go along with the installation or not. If check fails on any step listed in the rules, you won't be able to go on the installation.

Step iv: Setup Support Files.

At this step SQL Server Setup look for some components required during installation. After successful check you'll get Install push button to proceed farther. Click on Install Button.

Step 5: Setup Support Rules.

Again SQL Server runs a checkup after install to ensure whether your machine is OK or not for the installation. If yous become passed in all rules, you're good to go. Click Next.

Step 6: Installation Type

You lot detect this stride just if yous previously installed any instances of SQL Server on your motorcar. At this stride, you'll find 2 options i.e.

• Perform a new Installation
• Add together features to an existing instance.

As we want a new installation of default instance, we'll select kickoff option. If yous want to add together whatsoever additional features to your installed example, yous can go with pick two.

Select selection 1 and click Side by side.

Step 7: Editions and Production Fundamental

Hither it'll ask you lot the type of SQL Server edition you want to install on your automobile or on server. If you want express edition, no need to specify Production Key. Other editions like Enterprise, Standard, etc. requires Product Key. Click Next

Pace 8: License Term.

Click on "I take the license terms" and click Next.

Footstep nine: Feature Selection.

This is the of import step during installation considering at this footstep merely you'll select the features you desire to install. As we don't want Analysis and Reporting services now, we'll not add these ii components during installation process.

Select "Database Engine Services" and shared features.

Below y'all'll find the path where these shared features will get installed.

If you're installing this on 64-bit motorcar, y'all'll notice ii path boxes for shared features equally shown below.

Shared feature directory: To store 64-bit components.
Shared Feature directory (x86): To store 32-bit components.

I'm using 32-bit automobile hence I'thou only getting 1 path box as shown in above image.

Click Next.

Step 10: Instance Configuration

This is the step where y'all can specify what types of instance you want to install.

To install default instance of SQL Server, select "Default Instance" otherwise select "Named Instance" blazon the instance name and specify the example root directory.

Every bit we're installing Default instance, nosotros'll go with first option and select Default instance.

You lot tin only install 1 default example on a single machine. If default instance is already installed, you cannot select the "Default Case" pick.

Click Next.

Step 11: Disk Space Requirement.

At this step, information technology'll show y'all the required and available space on the drive you're installing the instance.

Click Next.

Step 12: Server Configuration.

This step volition determine how your SQL Services will run on your machine. Select the account proper noun from which you want to run your services and select the startup type of the service.

Click Next.

Step 13: Database Engine Configuration

This is the second most important step in installation process because here you'll configure your database engine.

Here you'll find iii tabs named

Account Provisioning (Shown in above image):

Here you'll select your Authentication Way and also yous'll setup your System Administration (SA) business relationship.

Select Authentication Mode equally Mixed Mode and enter SA password. Add together users as Sysadmin of the case by using "Add" push. Add together current user as SA admin by clicking "Add Electric current User".

Information Directories:

On this tab, yous'll go location of system databases, user databases, log file location, TEMP DB database location and too fill-in location. Y'all can change these settings every bit per your option.

FileStream

This tab will allow you to enable FileStream characteristic.

If you desire to acquire FileStream, you tin can read my commodity for the same on the following link.

• Introduction to SQL Server FileStream in 2008

Click Side by side.

Step 14: Mistake and Usage Reporting

Click Next.

Step 15: Installation Rules

Setup volition perform a check to ensure everything Ok to go along farther with installation. If all rule passes, click Next.

Step 16: Fix to Install

On this page, y'all'll go the summary of the configuration options you've chosen. Click on Install button to kickoff the installation process and track the progress as shown below.

When setup finishes, you'll get "Success" in condition column of each installed components.

Step 17: Installation completed

Your installation is completed and you'll become a link of a log file of the installation to check if there are any issues. Click shut to complete the installation process.

Fresh installation

If y'all're doing a fresh installation i.due east. yous're installing SQL Server for the commencement time on your machine, below are the steps to begin with.

Step ane: Open explorer and you lot'll encounter setup file as shown beneath.

Right click on the setup and run it every bit Administrator.

Stride 2: SQL Server Installation Centre.

Get to installation section, hither you'll notice various options to install instance, add new features and upgrade your SQL Server. As we're doing a fresh installation, we'll select first option i.e. "New SQL Server stand up-lone installation".

Step iii: Setup Support Rules,

Here setup will perform a bank check to ensure whether y'all tin go on with the installation or not. If bank check fails at whatsoever footstep listed in the rules, you won't be able to go along the installation.

Step iv: Editions and Product Key

Here it'll ask you the type of SQL Server edition you lot want to install on your auto or on server. If you desire limited edition, no need to specify Product Key. Other edition similar Enterprise, Standard, etc. requires Product Central. Click Adjacent

Step v: License Term

Click on "I have the license terms" and click on Next.

Step half dozen: Setup Support Files.

At this pace SQL Server Setup looked for some components required during installation. Later successful cheque you'll get Install push button to proceed further. Click on the Install Push.

Footstep 7: Setup Support Rules

Again information technology'll run the setup rules to identify problems that might occur during installation. If all checks become passed information technology is a practiced signal to proceed further. If any check fails, yous won't be able to go along further with installation. If condition is passed, click Adjacent.

Step eight: Feature Choice.

Click Next and later on this, all the steps are same as shown in above installation. After successful installation you'll get the post-obit window.

Now we've successfully installed SQL Server 2008 version on our machine. You can come across the installed SQL Server services under SQL Server Configuration manager every bit shown below.

Hit Outset button and type SSMS as shown below and information technology'll open up the SQL Server Management Studio.

Connect to your default case name by entering you SYSTEM name or past just putting DOT (.) in server name box equally shown beneath.

Decision

We've successfully installed SQL Server 2008 version on our machine. We accept seen the steps involved in fresh installation and also what are the steps involved when we install another case. In our adjacent article, we'll as well see how to install named instance on any machine and nosotros'll as well see manufactures on other SQL concepts. Till and so, Go along Learning and proceed sharing.

Source: https://www.c-sharpcorner.com/UploadFile/ff0d0f/sql-server-2008-installation-step-by-step/

Posted by: hopkinscooncers.blogspot.com

Share this post