Search This Blog

SQL Server 2005 Installation Step by Step

I found lots of queries in different forums regarding the installation of SQL Server 2005. If you don't have any other instances of SQL server running on the machine, the usual "Next -> next ... " will do. Now, if you have already SQL Server 2000 already installed on your machine, then the above approach won't be ideal, will just install the client tools only. So, what's to be taken care, you need to install 2005 as a 'Named' instance if you have any plans for multiple sql server installations or already one instance is running. 

So, What you are waiting for ? Put the SQL Server 2005 CD/DVD on your CD/DVD drive and start Installation.

Step1 : As with every setups, the Fist Step is accepting the EULA.

clip_image001

Step 2 : Now the installation will check for the pre-requisites

clip_image002

clip_image003

Once these validations are over, it will start installation 

clip_image004

Next step is the System configuration Check

clip_image005

Once the configuration check is complete, the actual Installation starts

clip_image006

Now you need to select the components to install

clip_image007

clip_image008

here comes the most Important part of the setup

Once you click ‘next’, it will ask for whether to install SQL Server 2005 as a Default Instance or as a Named Instance.

This is very critical, if you have already have an SQL Server 2000 installed on your machine. If the SQL 2000 instance is the ‘default’ instance and you are trying to overwrite that installation with the 2005, it will just install the client tools and no server components will get installed. So you won’t get the new features of SQL Server 2005. As you can see in the following diagram, I have chosen a named instance “SQL2005_1”

clip_image009

 

That's all, now you can continue the installation by the usual "Next->Next->Next..".

The next screen prompts  you to select service account details,if you wish, you can select different accounts for each services.

clip_image010

Authentication Mode : this is also very important, if you are installing on a "development / QE" machine, better go for "Mixed Authentication Mode".  Make sure that you put a complex password (something like your car registration number)

clip_image011

clip_image012

clip_image013

clip_image014

clip_image015

clip_image016

Now you can see, what are going on during the installation; what components are getting installed and what components "Failed"

clip_image017

If  you find all "Green", your installation is successful.

clip_image018

That's all. you can now start working on SQL Server 2005.

2 comments:

Aravind said...

Thanks Dude It helped me.

tatayya said...

thanks yaar, it was nice to see here.