Saturday, June 8, 2013

Learning Hyper-V Lesson 8

Previous lesson 7 we discussed about setting SQL mirroring but then I was not aware what I need to do to start with SQL mirroring.  I decided to blog SQL 2008R2 install steps. Remember I am doing this production for the first time in life :) So pop-in SQL 2008R2 CD/ISO and run the installer.

This will check all the prerequisite 

image

Next it will ask what feature we are trying to install. We are installing just SQL server .

image

We need to insure that we have choose "Integration Service" here

image  

This will check for all the dependencies for feature selected.

image

Go with default instance.

image

Now disk space will be calculated for above feature installation.

image

Configure all the service to run with service account.

image

Choose the correct authentication method which you want. Recommended is to use mixed mode.

image

If you wana to place data and log files on separate drives. Everytime when you create new database this will place MDF file and LDF file on respective drive.

image

One more check before installation begun.

image

Finally nice summary for what install is going to be done.

image

If install is successful it will present message with green.

image

No comments: