Installing SQL Server 2005

Installing SQL Server 2005

Before we begin the installation, login into the server with admin rights.

1.) Insert the SQL server CD DVD and wait for auto-menu to popup.

installing_sql_server_2005_1

2.) Under install menu click on Server components, tools, Books Online, and samples

3.) Then you will be prompted to agree with EULA, check the agree box and click next to install necessary prerequisites required to install SQL server.

installing_sql_server_2005_2

installing_sql_server_2005_3

4.) Next, it will display the welcome screen to begin installation of SQL.

installing_sql_server_2005_4

5.) After clicking on next, the setup will scan for system configuration. Errors (marked in red) should be corrected or installed before installation or else you cant proceed with installation. Warnings (marked in yellow) can be optionally installed or corrected and this wont prevent SQL from installing. Once corrections are made click on next.

installing_sql_server_2005_5

6.) The next screen is obviously regarding product key to begin with installation.

installing_sql_server_2005_6

7.) The next screen is where you are going to select the necessary component as per your requirement.

installing_sql_server_2005_7

8.) By clicking on the Advanced button you can see the below screen for further customization of your selected component.

 

 

 

installing_sql_server_2005_8

9.) Once components select, you will be prompted to select the instance you need (ie. Default or named instance). If any instances installed already, you can check by clicking on the installed instances button.

installing_sql_server_2005_9

10.) Next screen is where you are going to provide necessary credentials for you Sql services.

installing_sql_server_2005_10

11.) After clicking on next, you will be asked to select the authentication mode to install. You can change this option even after installing SQL, but requires SQL service restart.

installing_sql_server_2005_11

12.)The next screen is where you are going to select collation setting for your server. Be specific while choosing collation, because if you selected wrong one you need to re-install SQL server itself and there is no option to change it later.

installing_sql_server_2005_12

13.)Once done, you will be prompted with the below screen where you can enable disable send error and feature usage information directly to Microsoft.

installing_sql_server_2005_13

14.)On the ready to install screen, you can review your setting and then click install.

installing_sql_server_2005_14

15.)The setup progress appears during the install process as below.

installing_sql_server_2005_15

16.)The final screen gives you an installation report, letting you know whether any errors occurred. Click finish to complete the installation.

installing_sql_server_2005_16

17.) Reboot the system

18.) After logged in, go to the following path

Start –> Programs –> Microsoft SQL Server 2005 –> Configuration Tools > SQL Server Configuration Manager

Then check whether all the services are running fine.

installing_sql_server_2005_17

Leave a Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

*


x

Related Posts

SQL Server 2016 - Tempdb Configuration During Installation
After couple of years I'm started playing around the pre release packages. Today I installed Windows Server 2016 Technical preview release 3 and ...
Batch script to deploy multiple SQL files
I was working on a project where I’m supposed to deploy lots of SQL Server script files (.sql). It’s very tedious job either to manually execute ...
Installing SQL Server 2012
This might be a simple article for the intermediate folks, however I would like to show you the screen’s in SQL Server 2012 installation. As far ...
powered by RelatedPosts