Installing SQL Express 2014

Use the following step-by-step to install SQL Express.

Step by Step — Install SQL Express

  1. Launch the Estimate installer downloaded from the InEight website.

  2. At the User Account Control screen, click Yes to let the InEight Estimate application to make changes to your computer.

  3. On the Installation Package screen, click Install to continue.

  4. Select Microsoft Installers. This open the Microsoft Installers window.

  5. Browse to the Install folder for SQL Express 64 and then launch the SQLEXPR_x64_ENU installer.

  6. At the Choose Directory for Extracted Files screen, choose the directory where you want to extract the SQL installation. Then click OK.

  7. When the SQL Server Installation Center window appears, choose how you want to install SQL.

  8. If you are installing SQL for the first time, select New SQL Server stand-alone installation or add features to an existing installation.

  9. On the SQL Server 2014 Setup screen, under the License Terms section, check the box I accept the license terms. Then select Next.

  10. Under the Microsoft Update section, select Next.

  11. On the Feature Selection section, under Instance Features, select all three check boxes if they are not already checked. Then select Next.

  12. Under the Instance Configuration section, select the Named Instance radio button. Change the name in the text field to HDBID.

    • Notice the Instance ID field changed automatically to HDBID.

    • Select Next to continue.

  13. Under the Server Configuration section, select the Service Accounts tab.

    • Set the Account Name for the SQL Server Database Engine to NT AUTHORITY\SYSTEM.

    • Then select Next to continue.

  14. Under the Database Engine Configuration section, select the Server Configuration tab.

    • Set the Authentication Mode to Mixed Mode.

    • For the SA Account, enter the password: Hard$123abc.

    • Then select Next to continue.

  15. The installation was successful, click Close.