Previous Topic

Next Topic

Book Contents

Book Index

Installing SQL Express

The installation files for Microsoft SQL Express are located in the SQLExpress folder of your QikKids CD. Begin by ensuring that you have the latest Windows Service Pack installed for your operating system.

  1. Disable any virus checkers before installing new software
  2. Browse to the SQLExpress folder on your QikKids CD
  3. Double click dotnetfx.exe to install the .NET Framework Runtime (version 2).
  4. Double click SQLEXPR.EXE to install SQL Express.

In general you can accept the default options for the various screens presented during installation, however there are a couple of options that are worth changing to simplify administration and connection.

Disable Hide Advanced Configuration Options

Remove the tick from Hide Advanced Configuration Options

Install as Default Instance

By default SQL Express installs as a named instance. Unless you have multiple installations of SQL Express on the same server, install it as the Default Instance

Enable Mixed Mode Authentication

.

Once SQL Express set up has completed successfully, you should also install the manager interface

  1. Double click on SQLServer2005_SSMSEE.msi to install the SQL Express Management Studio. Accept the default installation options.
  2. (Optional) Install SqlExpressBOL for the latest documentation on SQL Express.

See Also

SQL Server Express

Starting a QikKids Database

Allowing Network Connections