Issue: QMIS stores it’s data in a Microsoft SQL Server Express 2005
database. The QMIS install will automatically install this database. However, in
certain circumstances, that portion of the install will fail. In that case, you
can, from the installation CD, select the Additional Tools button and click on
SQL Server Express 2005. This should install SQL Server Express.
It’s been noted that the above steps may fail. In that case, you can download
SQL Server Express directly from Microsoft and install it manually using the
steps below.
Resolution:
1.
Download SQL Server Express 2005 from the Microsoft download site,
http://go.microsoft.com/fwlink/?LinkId=65212 and run the installer.
2.
After you agree to the license agreement, you will see a screen where it
needs to install prerequisite. Click Install to install these (the prerequisites
are not optional.)
3.
Next you will see the Microsoft SQL Server Installation Wizard. Click
Next to continue.
4.
The install will verify that your system meets the minimum requirements
and will present you with a screen showing the results. If anything is
insufficient to run SQL Server 2005, it will be noted.
5.
In the Registraion Information screen, uncheck the Hide advanced
configuration options checkbox and click Next.

6.
Make no changes to the Feature Selection screen, just click Next.

7.
The Instance Name will show SQLExpress. Change it to QMISExpress and
click Next.

8.
Make no changes to the Service Account screen – just click Next.

9.
In the Authentication Mode screen, select Mixed Mode and enter @qmispass1
into both of the password screens and click Next.

10.
Make no changes to the Collation Settings screen – just click Next.

11.
The User Instances screen is also fine – just click Next.

12.
Leave the Error Report Settings screen as is – just click Next.

13.
Finally click Install to commence with the installation.

If you will be running QMIS on the network, and if this computer is the
one that will host the QMIS data, follow the steps below to configure SQL Server
Express 2005 for network access.
1.
Click on Start, All Programs, Microsoft SQL Server 2005, Configuration Tools,
SQL Server Surface Area Configuration.

2.
Click on Surface Area Configuration for Services and Connections

3.
Under the QMIS Express instance,
click on Remote Connections, then click on Local and remote connections
and select Using both TCP/IP and named pipes. Next, click on Apply.

4.
Click OK on the resulting message

5.
On the left side, click on Service, then click the Stop button.

6.
Your computer will stop the SQL Express service for QMISExpress.

7.
Finally, click the Start button to restart the QMIS Express service. Once it's
started click the OK button to close the Surface Area Configuration tool.
