(QKB052406.1) How to manually install SQL Server Express 2005
5/24/06

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.

 

If you require further assistance, please contact our Customer Support department at (800) 646-8238 Monday through Friday 7:00 AM to 5:00 PM Pacific Time, or .

 


 

Information provided in this article is supplied "As is." That is, while Friedman Corporation makes every attempt to verify the accuracy of the information contained herein, we acknowledge that every computer setup differs, just as every computer user differs. For this reason, your experience may not produce the results expected in this document. Thusly, Friedman Corporation makes no claims as to the warrantability, veracity or accuracy of any information in this article. Furthermore, if you implement any of the  suggestions contained herein, you agree to hole Friedman Corporation blameless for any malfunction in your computer or software programs. In no event will Friedman Corporation be liable to you for any damages, including any lost profits, lost savings, or other incidental or consequential damages arising out of the use or inability to use the program even if it has been advised of the possibility of such damages.

 
 
   

Copyright © 2007 Friedman Corporation

 

Please report any errors or omissions on this site to the

 

Home   |   Support  |  Downloads  |  Vendor Catalogs  |  Training  |  Contact Us