The next dialog box is the Collation Settings dialog box. Collation settings define the sorting behaviour of the server. SQL server collations are used for setting up compatibility with earlier versions of SQL Servers.

The Report server database setup dialog box which appears requires the user to specify the instance of the SQL Server which will host the report server database. Select Host in current instance of SQL Server and specify the report server database name and click next to continue

The Next dialog box is the Report Server Delivery Settings dialog box. The user has to specify the parameters required for sending email reports. Click Next to continue if you do not wish to enter any details here.

The Error Reporting dialog box appears prompting the user that SQL server, its components and Analysis services will be configured to send fatal service error reports to Microsoft or a corporate error reporting server. The user can select the check box and click next as this helps Microsoft in monitoring its services and improving upon its software. Click Next to continue.

The ready to install dialog box displays all the components that are going to be installed on the system. To proceed with the installation the user has to click on Next.

The setup progress bar is displayed. On completion of set up the Next button will become enabled and the user has to click on Next to proceed.

The next dialog box displays all the files that are being configured. The user has to click on Next to continue.

The last dialog box displays the progress of the set up. All the selected components being configured are displayed and their status indicated. Click on Next to continue.

This takes the user to the final screen of the setup. The system is required to be rebooted for the configuration to take effect. The user is asked to click on finish to reboot the system. The user is informed that any errors in set up are recorded in the summary log for future reference. Click on Finish to complete the process.

In this lesson we have completed the set up of SQL Server 2005. In the lessons that follow we shall explore the new features of SQL Server 2005.

First Page: Getting started with SQL Server 2005