SQL Express 2016 Manual Install

SQL Express 2016 Manual Install

SQL Express 2016 Manual Install

1.0Introduction

You can encounter a situation where you need to manually install the SQL Express database engine and database management tools (SQL Studio Express. This article walks you through the process of manually installing SQL Express 2016 onto a 64-bit installation of Windows 10.

 

Notes:

  • You should be logged into the PC with full administrative rights to perform this installation.

  • SQL 2016 does not work with 32-bit versions of Windows. Therefore, if you are using a 32-bit version you will have to manually download and install SQL Express 2014 - which is the most recent version of SQL Server that supports a 32-bit operating system. Keri Systems includes the new SQL Server Express 2016 with the Doors.NET installer but sometimes there is a security setting, such as in a Server environment, that may not be easily bypassed or resolved - or the database my need to reside on a different PC.

 

2.0Download the SQL Express 2016 Installer

The installer for SQL Express should be downloaded from the Microsoft website. At the time of writing, the official URL is as follows:

 

https://www.microsoft.com/en-us/download/details.aspx

Download_SQL_Express_2016

  1. Visit https://www.microsoft.com/en-us/download/details.aspx?id=56840.
  2. Click the bright red download button.
  3. The installer should download within a few seconds.
  4. Locate the installer on the host PC, (highly likely to be the Windows Download directory).

 

3.0Install SQL 2016 Express
  1. Go to the Downloads folder on the host PC.
  2. Click on the SQL Server 2016 Express installer executable.

    Installer

  3. Select the 'Custom' installation option.
  4. Review the target download location for the installation media.
  5. Click the INSTALL button in the bottom-right.
  6. The entire installation media will first be downloaded (approx. 1.4GB). A reasonably fast internet connection should allow for the download to complete in just a few minutes.
  7. The setup files will be extracted.
  8. When the Installation Center window appears, click on the first option 'New SQL Server stand-alone installation or add features to an existing installation.
  9. The installer first gives you the option to check for updates to the Windows operating system. Keri systems recommends that you do check for updates before proceeding. So place a check in the check-box and click the NEXT button. The installer will check for updates, it will download setup files and then extract the setup files.
  10. You will then see the Installation Type window - here you should choose the option to 'Perform a new installation of SQL Server 2016. Click NEXT again.

    Perform New Install

  11. You should then read through and accept the Microsoft software license terms. Click NEXT.
  12. The feature selection screen appears next. You should leave all default selections in place (do not deselect any of the features). Click the NEXT button.
  13. The Instance Configuration screen now appears. On this screen you should type in the instance name as ECLIPSE. All uppercase letters.

    ECLIPSE

  14. You should accept the default settings on the Server Configuration screen. NEXT again.
  15. You will now see the Database Engine Configuration screen.
  16. You must set the authentication mode to 'Mixed Mode (SQL Server authentication and Windows authentication)'.
  17. Enter the 'sa administrator' password as 'dhs$e700'.
  18. Enter dhs$e700 a second time to confirm the password. All lowercase characters.

    Mixed Mode

  19. Click NEXT.
  20. On the Reporting Services Confirguration screen, leave it set to the default option (install and configure). Click NEXT.
  21. Click the ACCEPT button to consent to installation of Microsoft R Open. This also agrees to accept all associated future updates and patches. Click the NEXT button again.
  22. SQL Express 2016 will now install on the host PC.

    Install_Progress

  23. The installation should take approximately 5 minutes to complete.
  24. During the install, you may see a notification that the PC requires a restart. If so, click OK to proceed with the restart.

    Restart pending

  25. Once the PC has restarted SQL Express 2016 will have been installed.

 

 

4.0Install SQL Studio Manager 2016

You should now ensure that Studio Manager database management tools is also installed on the host PC. Studio Manager allows you to perform database administrative functions, such as attaching and detaching a database, deleting a database, restoring a database and viewing and editing database tables and database values.

 

4.1On a standalone host PC (that does NOT have Doors.NET Installed)
  1. Open a web browser and navigate to the following location: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15
  2. Keri Systems recommends downloading and installing the most recent version of Studio Manager.
  3. Click 'Download SQL Server Management Studio (SSMS)'. The file is approx 550MB - So it should download in just a few minutes.
  4. Once downloaded, navigate to the Downloads directory.
  5. Double-click the SSMS-Setup-ENU file.
  6. When the Welcome screen appears click on the INSTALL button.
  7. Studio Manager installation should complete in a few minutes.
  8. Restart the PC when prompted to do so.

 

4.2On the Doors.NET Host PC (Which DOES have Doors.NET Installed)

If you have Doors.NET installed on the host PC you can download and install Studio Manager via the License Manager.

 

  1. From Windows Start menu go to Doors.NET >> License Manager.
  2. On the right, you will see the 'Database' section - The red text above the Install SQL Studio button should state: 'Not Installed'.
  3. Click the Install SQL Studio Button.

    SQL Studio Not Installed

  4. First the installation files will be downloaded.
  5. Once downloaded, click the install SQL Studio button again to perform the installation.
  6. Installation of SQL Studio Manager should take just a few minutes.
  7. Once complete, close then re-open License Manager.
  8. Select Application Server again and SQL Studio should be indicated as installed.

    DB Now Installed
  9. You can now close the License Manager.

 

5.0Manually Install the Doors.NET Database

If the database will reside of a different PC to the application server PC then you will need to install the database manually.

 

When you install the Doors.NET software there is a utility automatically created in the C:\Keri\DoorsNET directory. This utility can be used to manually install the Doors.NET database, such as for a situation where the database needs to be located on a different PC/Server, or where there is an existing SQL Server.

 

  1. Locate InstallDHSDB file within C:\Keri\DoorsNET.

    InstallDHSDB - Image 1

  2. Run the utility if you are on the database host PC or copy the file to a storage device such as a USB drive to run on a different PC/Server.
  3. When the utility opens you will see the option of either installing a new database or updating an existing database. Select to Create a new database then click Next.
  4. Ensure Create a New Database is selected, click NEXT.
  5. Enter the new database name as 'DHS_MAIN'. Click NEXT again.
  6. The database settings screen appears next. In most situations using the default values should be fine. Click NEXT again.

    DB Settings

  7. Click the PROCESS button and the Doors.NET database installation will begin.

    DB Installing

  8. The database installation should complete within a few seconds.
  9. Click EXIT to exit the InstallDHSDB utility.

 

6.0Test the Database Connection

Once the database and SQL Studio Manager are both installed you should test the connection to the database.

  1. With Application Server still selected (listed on the left).



    App Server Selected

  2. Then click the SETTINGS button.



    Settings

  3. Your database connection settings should appear as shown here:

    LM Database Settings

  4. Click the TEST CONNECTION button.

    Test_Connection_Button
  5. Then YES to proceed.
  6. Almost immediately you should see a connection successful message.

    DB Connection Successful

  7. Click the SAVE button
  8. You will then be prompted to start the Application Server Windows service.
  9. Moments later you will see a message confirming the Application Server is started.

    App Server Selected
  10. You are now ready to use your Doors.NET system.

 

7.0Further Information

For further information about adding cardholders to Doors.NET, adding hardware, backing up and restoring the database, etc, please refer to the help file which is included in the program.

 

The help file can be accessed via the Keri logo image in the top left corner of the client.


Online Help Link

Or you can access it by pressing the F1 key while on any screen. The help file will open out on the page related to the screen you are on.

Help File Open




    • Related Articles

    • SQL Express 2014 Manual Install

      1.0 Introduction This document applies to 32-bit operating systems that do NOT support SQL 2016 (for example; Windows 10 32-bit). With the release of Doors.NET v4.0.1 Keri is now using .NET Framework v4.6.2 and SQL Express 2016. This allows the ...
    • Doors.NET - Upgrade the SQL Express Version

      1.0 Introduction Windows 11 has been approved for new installations of Doors.NET software from v4.8.0 and newer. Windows 11 has been approved for older installations of Doors.NET software under the following conditions: * The installation is upgraded ...
    • Doors.NET - Full Manual

       1.0 Introduction   Welcome to the Doors.NET full manual. This comprehensive document covers everything you would need to know to setup and use a standard Doors.NET access control system and the NXT-MSC controller types. The document consists of ...
    • Doors.NET - Download and Install SQL Studio Manager

      Install Studio Manager on the Doors.NET Host PC (via License Manager) If you have recently installed on the host PC you can then quite easily download and install Studio Manager via the License Manager. From Windows Start menu go to Doors.NET ...
    • Doors.NET - Installation Using an Existing SQL Server

      If you are installing the software onto a network that already has an SQL Server available and you want to use that server for the database, you need to install the Application Server only. The default database will be installed in the C:\Program ...