ALMSys, Inc.

2012 Express Installation Instructions

Microsoft SQL Server is used for both the ALMSys® and Lading Manager™ (full) software products. The standalone versions of these products have made use of the runtime version of SQL Server, called "SQL Server Express."

This covers installing SQL Server 2012 Express. These instructions are for standalone SQL Server users only. Network SQL Server users should obtain SQL Server 2012 through your normal IT channels.

Windows 7/8 Note: When installing on Windows 7/8, you will need to first download the files, and then right-click on each file and run them as the administrator.

These instructions will walk you through the process of installing SQL Server 2012 Express. If you want assistance, please do not hesitate to contact Support.

  1. You must be logged on as the Administrator of your PC in order to update it.


  2. Download and run Microsoft SQL Server 2012 Express. Choose the version that matches your computer.

    Here are the steps that the installation will go through. You will need to take the correct action on each step.

    1. It will go through an "Extracting files" phase. No action is required.

    2. SQL Server Installation Center. Select "New SQL Server stand-alone Installation." This will open a new window for the setup.

    3. Accept the license terms. Click Next.

    4. Product Updates. Click Next.

    5. Install Setup Files. This will download the product updates (service packs), unpack them, and install them. This step may take awhile.

    6. Setup Support Rules. You may not see this screen.

    7. Feature Selection. Click Next.

    8. Instance Configuration. The named instance should be "SQLExpress." If it does not state "SQLExpress," then write down the instance name presented (or make up an instance name of your own). You will need this later. Click Next.


    9. Server Configuration. In the "Account Name" column on the "SQL Server Database Engine" line, it should be filled in with "NT Service/MSSQL$SQLEXPRESS." When that has been filled in, click Next.


    10. Database Engine Configuration. Select "Mixed Mode." You now must supply a strong password twice and start it with an uppercase letter. A strong password consists of upper characters, lower characters, and numbers. You may put in dashes and underscores. The password must be at least 8 positions. Write down this password. You will need it later. Click Next.


    11. Error Reporting. Click Next.


    12. Installation Configuration Rules. This will flash past.


    13. Installation Progress. This will go right into the install...and will take awhile.


    14. When the installation has completed, close all of the windows.


  3. Typically, there is no need to reboot unless you are asked to.

(Use your browser's Back button to return.)