Installing SQL Express 2008 on a Windows 2003R2 Server

Recently, I had the opportunity to instal MS SQL Express 2008 on a Windows 2003R2 Server for a client for wanted to check it ou befire upgrading to SQL Server 2008.

Here are the steps that I took :-

1) Download SQL Express 2008 with Advanced Services

2)

Ran it and discovered that I had to download and install the following components

ASP.Net 3.5SP1
Windows Power Shell 1.0
Windows Installer 4.5 and above

3) Took a while to download 50 Plus MB of ASP.Net 3.5SP1 and installed it without issue

4) Installed Windows Power Shell with no issue

5) Installed Windows Installer 4.5 again with no issue

6) Ran SQL Express 2008 with Advanced Services again and passed all requirements

Tips


a) Use NT Authority/SYSTEM
b) Use Mixed Mode for authentication



More to come...