The Management by Statistics 3 uses Microsoft SQL Server to manage your information in database files. SQL Server was choosen because of its robust features and rugged operations. It is capable of handling hundreds and thousands of users on a routine basis, while at the same time being compact enough for single computer operation.

There are times when a computer either does not have the features required to run SQL Server or one or more of these features has been disabled. In these cases, the installer for the Mastertech Database Manager will instruct you to install SQL Server manually.

A manual install of SQL Server will identify exactly which feature(s) is missing from your computer so that you can correct this.

IMPORTANT NOTE: You must be logged into Windows as an Administrator.

Manual Installation of SQL Server Instructions:

1. Download the SQL Server 2008 Express installation file by doing the following:
   
   
   1. Go to the following link at Microsoft to download the SQL Server Installer:
      http://www.microsoft.com/downloads/en/details.aspx?FamilyID=01af61e6-2f63-4291-bcad-fd500f6027ff&displaylang=en
      
      
   2. Select the download button for "SQLEXPR_x86_ENU.exe", as shown below.
      
         
      
      
   3. Click the Save button. The installer will be saved in your computer's Download folder.
      
         
      
      
2. Run the SQL Server Installer "SQLEXPR_x86_ENU.exe" located in your download folder.
   
   
3. The installer window will open. Click on the “Installation” item along the left side.
   
      
   
   
4. Click the first item New SQL Server stand-alone installation or add features to an existing installation.
   
      
   
      
   
   
5. You will get a screen like the one below. In this part of the installation the installer checks certain parts of your system to make sure it is set up correctly to accept SQL Server. Anything listed as Failed needs to be corrected before SQL Server will install.
   
      
   
   Click Ok to continue the installation.
   
      
   
   
6. A screen like the one below will be displayed.
   
      
   
   Click the Install button.
   
      
   
   
7. Next you will get a report showing if the system passes for installation of SQL Server. If there is a firewall on the computer, then you should receive a warning that the firewall needs to be configured to allow access to SQL Server for it to receive requests from other computers. An example of this is shown below.
   
      
   
   IMPORTANT NOTE: Any failed parts will need to be handled. The warning about Windows Firewall is automatically resolved by the Mastertech Database Manager. If you are using a 3rd party firewall on your computer, then you will need to set that firewall to allow connections to SQL Server after the installation is completed. See the manual for your firewall for instructions on how to do this.
   
   Click Next to continue.
   
   
8. Select the first item, "Perform a new installation of SQL Server 2008". Click Next to continue.
   
      
   
   
9. The next screen will have disabled options as this is the free version of SQL Server. Simply click Next and move on.
   
      
   
   
10. The next screen is for accepting the license agreement. Read the license agreement and select “I accept the license terms” and click Next.
    
       
    
    
11. Select all of the options. Then click Next.
    
       
    
    
12. On the following screen type the Instance name MBSDATAEXPRESS. This is where you tell SQL Server what drive to install to. Once you have entered MBSDATAEXPRESS, click Next.
    
       
    
    
13. The next screen is an information screen and it will inform you if there is enough space on your hard drives for the installation of SQL Server. Click Next.
    
       
    
    
14. The next screen is where you tell SQL Server how it is to start up. IMPORTANT: For the SQL Server Database Engine you MUST select a user. Select “NT AUTHORITY\SYSTEM” from the list. Click Next.
    
       
    
    
15. This next screen has two tabs that we are interested in.
    
    IMPORTANT: You need to do the following on the first tab (Account Provisioning).
    
    
    1. Select Mixed Mode.
    2. Enter a password for the built-in SQL Server administrator account. Enter the same password twice.
    3. Click the “Add Current User” button at the bottom. This gives you rights to configure SQL Server after it has been installed.
    
       
    
    IMPORTANT: By default you do not need to change the data directories for SQL Server. Some people may want to.
    
    To use the default settings, skip this part and just click Next.
    
    If you want your data to be stored in a different place on the hard drive than the default, then you can change the data folders in the Data Directories tab.
    
    If you want to change the drive and directory where the data is stored, we recommend that you set the User database directory and User database log directory to the same place. This is simply to keep your data files organized.
    
    Click Next to continue.
    
       
    
    
16. Leave the options on this next page turned off unless you want participate in Microsoft’s error collection program.
    
       
    
    
17. The next screen checks the installation for correctness. Click Next if there are no Failed or Warnings. If you get a failed item, then correct what it tells you to correct.
    
       
    
    
18. The next screen is an information screen. Click Install.
    
       
    
    
19. If all is good, the installation will go through to completion.
    
       
    
    Click Next.
    
       
    
    The file shown in the link will contain a complete log of the installation, if there is something that needs to be debugged.
    
    
20. You are now ready to install the Mastertech Database Manager.