SQL Express 2016 Manual Install

Introduction

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 have 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.
  

Download 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?id=56840

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).

Install SQL 2016 Express

1. Go to the Downloads folder on the host PC.
2. Click on the SQL Server 2016 Express installer executable.
   
   
   
   
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.
    
    
    
    
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.
    
    
    
    
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.
    
    
    
    
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.
    
    
    
    
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.
    
    
    
    
25. Once the PC has restarted SQL Express 2016 will have been installed.

Install 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.

On 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.

On 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.
   
   
   
   
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.
   
   
9. You can now close the License Manager.
   

Manually 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.
   
   
   
   
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.
   
   
   
   
7. Click the PROCESS button and the Doors.NET database installation will begin.
   
   
   
   
8. The database installation should complete within a few seconds.
9. Click EXIT to exit the InstallDHSDB utility.

Test 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).
   
   
   
   
   
   

2. Then click the SETTINGS button.
   
   
   
   
   
   
   
   
3. Your database connection settings should appear as shown here:
   
   
   
   
   
   
   
   
4. Click the TEST CONNECTION button.
   
   
   
   
   
   
   
   
5. Then YES to proceed.
6. Almost immediately you should see a connection successful message.
   
   
   
   
   
   
   
   
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.
   
   
   
   
   
   
   
   
10. You are now ready to use your Doors.NET system.

Further 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.

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.