MacLochlainns Weblog

Michael McLaughlin's Technical Blog

Site Admin

SQL Server 2008 Express

with 18 comments

Installing Microsoft SQL Server 2008 Express was an interesting experience. After downloading it, the software patched and rebooted my Microsoft Vista machine 4 times before beginning the installation. Once started, it only took 55 minutes and 37 seconds to install it.

SQL Server 2008 Express Installation

Here are the steps if you’re interested in installing it.

After you download the file, you’ll need to launch the program from the following dialog. Click the Run button to continue.

seinstall01

The next screen requests you accept the license agreement. Please make sure you do that or you could run into trouble later on if you violate the EULA. Click the Accept button to continue.

seinstall02

The installation will start and then you get to wait. It is at this point that the installer will examine and patch your operating system. While you think you’re up-to-date, you’ll probably see a couple patches applied before the real installation starts.

seinstall032

After you start the installation, you’ll see this dialog. It’ll even reappear after completing the install, and ultimately you may need to click the Cancel button. You don’t have to worry at that point because it’ll be installed.

seinstall04

After you’ve started, this is the dialog you’ll get after applying operating system patches. You’ve really no choice but to reboot if you want to install SQL Server 2008 Express successfully.

seinstall05

This is the first installation screen. Make sure you select the correct version of SQL Server 2008 Express. Typically, you’ll want the one with Advanced Services. Click the appropriate radio button, and then the Install button.

seinstall06

When you see this dialog, you’re installation has truly begun. Don’t click the Cancel button now.

seinstall08

The file extraction takes several minutes. Have something ready while you wait or take a break.

seinstall09

After the file extraction, you’ll see the SQL Server 2008 Setup Support Rules dialog. Click the OK button to continue.

seinstall10

You only get a choice on this dialog if you’re installing the full version. Choose Next to continue.

seinstall11

Check the I accept the license terms box, and then the Next button to continue.

seinstall12

All the rest was plumbing. Now you start the SQL Server 2008 installation. Click the Install button to continue.

seinstall13

You’ll see this for a few minutes before you’re prompted to continue.

seinstall14

You should get all check marks but a lot of folks forget to open the firewall ports. If you forgot, this is what you’ll get as output. Return to the top of the post and open the required ports before continuing. When you’ve opened the ports, click the Next button to continue.

seinstall15

You’ll get this prompt only when you failed to open the ports before beginning the installation. Click the OK button to continue.

seinstall16

The Feature Selection dialog is important. You should probably make the same choices as shown if you’re deploying a development machine. That’s really all you’d want to do with SQL Server 2008 Express edition. Click the Next button to continue.

seinstall17

Now you accept the installation of SQLExpress as the named instance by clicking the Next button.

seinstall181

Now you accept the 1,446 MB space requirement by clicking the Next button.

seinstall19

The account name must be an authorized user account defined by the operating system or left blank. If you want to set it up for local system authentication against Operating System accounts, you must select from the list of values. If you want to provide credentials manually, leave it blank! Click the Next button to continue.

seinstall20

The easiest way to enter a valid credential is to click the Add Current User button. It’ll load it right where you see authorized user in the screen shot. Click Next to continue.

seinstall21

Choose which pieces of information you’d like to send. Not checking anything is also an option. Click Next button to continue.

seinstall22

Now the install will check if everything works before attempting it with the rules you’ve entered. Click the Next button to continue.

seinstall23

After verifying the installation is possible, you’ll see what you’re installing before you click the third Install button to continue.

seinstall24

It is now time for another break while SQL Server 2008 Express edition installs.

seinstall25

If you arrive at the next screen, SQL Server 2008 Express is installed.

seinstall26

Now you’ll see the final installation dialog and the link to the installation log file.

seinstall27

Now the final prompt before configuration. Yes, you must now reboot the system again.

seinstall28

You’ve now installed SQL Server 2008 Express. However, if you want to use the command line client tool, sqlcmd.exe, there’s more work. I posted those steps in this other blog entry.

Written by maclochlainn

March 30th, 2009 at 9:08 pm

Posted in SQL Server 2008