Learning Sql Server Skills

Installation of SQL Server 2008:

You can download the SQL Server 2008 installation software from one of the following links.

http://www.microsoft.com/en-us/download/details.aspx?id=1279

http://sqlserver.dlservice.microsoft.com/download/9/C/0/9C036510-3218-4258-8B03-67DC1D6A497C/SQLFULL_ENU.iso?lcid=1033

You can download the SQL Server 2012 installation software from the following link.

http://www.microsoft.com/sqlserver/en/us/get-sql-server/try-it.aspx

The above links provides the software in the image form, so after you download the software image file, that image file has to be written onto a DVD disk. Then you can copy these files from DVD disk to one of your hard disk drives.

Now you can see all the files as shown in the below screen shot.

Once you copied the software to the hard drive, follow the below steps to install the SQL Server 2008 successfully on your windows machine.

Pre-requisites:

The SQL Server needs the following applications should be installed before installing SQL Server in your machine.

1. Net Framework

2. SQL Server Native Client

3. SQL Server Setup support files

The above applications will be installed before starts the actual installation of SQL Server.

Follow the below steps to starts the installation of SQL Server 2008.

Double click on the Setup.exe, then the SQL Server prompt you to check for any compatibility issues as shown below.

Click on Run program.

Now the SQL Server prompts the window as shown below to choose right installation.

Choose the Installation page from the left side pane. You can see the following window.

Now click on the selected link that will start installation of a new stand-alone SQL Server. You can see the following window.

Click on Run program.

Now the SQL Server prompts the window as shown below

SQL Server will check all the installation files are valid or any corrupted. If it founds any corrupted or invalid files, it won't allow you to install and shows the error details in the errors list.

Now there are no errors, no warnings..

Now click on OK

Click on Install.

Setup support rules identify problems that might occur when you install SQL Server Setup support files.

Now click on Next.

Now you can choose to perform a new installation or add features to an existing instance of SQL Server 2008.

Now click on Next.

Click on Next.

Now you have to accept the license terms. Click on Next.

Now you can choose the necessary features to install. You can choose the 'Select All' to install all the features. Now clink on Next.

Now you have to choose the whether you are installing default instance or named instance.

Click on Next.

Now you have to choose an account on run the SQL Server and SQL Server Agent services. You can set these account by using the following screenshots.

Click on the browse, you can see below window to choose an account.

Click on Advanced button, then you can see the below window.

Click on Find Now button, then you can see the list of all available users including Administrators.

Choose an appropriate account and then click OK.

Now I have selected the Account Name as 'NT AUTHORITY\SYSTEM' account for both SQL Server and SQL Server Agent services to run on the system as shown in the above screenshot.

Specify database engine authentication security mode, data directories and administrators. Click on the Data Directories tab. The default locations are referring the installation directories.