Moha: Created page with "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 a..."

2011-06-03T20:43:45Z

Created page with "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 a..."

New page

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.

[[File:2009-10-21_102830.png]]

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

[[File:2009-10-21_102929.png]]

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.

[[File:2009-10-26_122951.png]]

Click 'Install'. The following screen will open.

[[File:2009-10-26_123008.png]]

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

You will be presented with the Authentication mode screen.

[[File:2009-10-26_123449.png]]

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.

[[File:2009-10-26_123736(1).png]]

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

[[File:2009-10-26_124055.png]]

Click 'Yes'.

When your system restarts the installation will automatically continue.

[[File:2009-10-26_130052.png]]

Microsoft SQL Server 2008 will begin its installation.

[[File:2009-10-26_141133.png]]

When the install is finalizing you will see this message.

[[File:2009-10-26_141335.png]]

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

MS SQL 2008 is now installed:

[[File:2009-10-26_141411.png]]

Click 'Exit'

[[File:2009-10-26_141644.png]]

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.'''

[[File:2009-10-26_141756.png]]

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

[[File:2009-10-26_141756-b.png]]

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.

[[File:2009-10-26_141954.png]]

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'.

[[File:2009-10-26_142027.png]]

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

[[File:2009-10-26_142110.png]]

Microsoft SQL Server 2008 is now configured for SME.

Installing MS SQL Server 2008 - Revision history

Moha: Created page with "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 a..."