Installing MS SQL Server 2008

Installing Microsoft SQL Server 2008 using the Web Installer:

Note: The Web Installer will not install MS SQL Server if you are running MS SQL 2005 or earlier.

Open a browser and navigate to: http://www.microsoft.com/express/sql/download/

Scroll to the bottom of the page and click on the Runtime with Advanced Services 'Install' button.

If you have not yet used the Microsoft Web installer you will be redirected to the following page:

Click on the green button labeled 'Get the Microsoft Web Platform.

Answer 'Run' to the various prompts and you will be presented with the following screen.

Click 'Install'. The following screen will open.

Leave the 'SQL Server 2008 Express with Advanced Services' checked and click 'I Accept'.

You will be presented with the Authentication mode screen.

Leave the authentcation mode as 'Mixed Mode'.

Enter a password. The password must be a 'Strong' password continaing a mix of Capiatl letters, numbers, and special characters like, @#$%.

Click 'Continue'. Windows Powershell will begin installing.

When the Windows Powershell is finished installing you will need to reboot your computer:

Click 'Yes'.

When your system restarts the installation will automatically continue.

Microsoft SQL Server 2008 will begin its installation.

When the install is finalizing you will see this message.

When the installation is complete you will see the Congratulations screen.

MS SQL 2008 is now installed:

Click 'Exit'

You will now have the Microsoft SQL Server 2008 Program group in your start menu.

The next step is to configure MS SQL Server 2008 for remote connections.

Expand the SQL program group and select the 'SQL Server Configuration Manager'.

When the 'SQL Server Configuration Manager' opens you will need to make the following changes:

Turn on the FTS (Full-text Filter Search) service. Expand the services by clicking on the SQL Server Services in the left column.

Right click on the SQL Full-test Filter service and select Properties.

Select the Service Tab.

Click on Start Mode and in the right drop down select 'Automatic'.

Click 'Ok'. When the change is saved right click on the service and select 'Start'.

Microsoft SQL Server 2008 is now configured for SME.