1. Create a certificate

To use HTTPS with DLM Dashboard, you'll need to create a certificate on the machine DLM Dashboard is running on. You may need to ask your system administrator to help you create a certificate. The certificate must be created on the machine DLM Dashboard is running on. If you aren't using this machine, you'll need to remote access the machine to follow these steps:

1. Open Microsoft Management Console (mmc.exe), running as administrator (right-click and select Run as administrator):
   
   
2. From the File menu, select Add/Remove Snap-in.
3. From the list of available snap-ins, double-click Certificates.
4. In the Certificates snap-in dialog window, select Computer account and click Next.
5. Select Local computer and click Finish.
6. Click OK to close the Certificates snap-ins dialog.

This machine now has a certificate for DLM Dashboard to use.

2. Configure Windows

Now you need to configure Windows to use that certificate with DLM Dashboard:

1. In the navigation pane of Microsoft Management Console, open the Certificates folder: Console Root>Certificates (Local Computer)>Personal>Certificates
   
2. A list of certificates is displayed in the right hand pane. 
3. To open the new certificate, double-click the entry with your machine name (eg INT-EXAMPLE.red-gate.com).
4. Select the Details tab.
5. From the list of details, select Thumbprint.
6. Make a note of the value displayed at the bottom of the window (you'll need this in step 8):
   

7. Open a command prompt window (cmd.exe) running as administrator.
   To do this, right-click on the Start menu entry and select Run as administrator:
   

8. Run netsh then http so that your command prompt looks like this:

   netsh http>

9. Copy the following command, replacing:

   • certhash with your certificate thumbprint value, without spaces

   • ipport with 0.0.0.0, followed by an available port number

   • appid with a new GUID. See Globally-Unique Identifier (MSDN).

   add sslcert certhash=‎e28903f2bd48a0b910219543ace9bf8e487b93da ipport=0.0.0.0:443 appid={00112233-4455-6677-8899-AABBCCDDEEFF}

10. Run the command.

Windows now uses this certificate for connections to the new port number.

3. Configure DLM Dashboard

Now you need to configure DLM Dashboard to use the new port number and HTTPS:

1. Open a text editor, running as administrator (right-click and select Run as administrator):
    
2. Create a new file
3. Save it as UserSettings.config in the folder C:\Program Files (x86)\Red Gate\DLM Dashboard 1\WebServer\bin\Release
   If that folder doesn't exist, save the file in C:\Program Files (x86)\Red Gate\SQL Lighthouse 1\WebServer\bin\Release

4. In the file, copy and paste the following:

   <?xml version="1.0" encoding="utf-8"?>
   <appSettings>
       <add key="Owin.Urls" value="https://*:443/" />
   </appSettings>

5. Edit the value of Owin.Urls to: 
   

   • replace the port number with the new port you want to use 
   • make sure the hostname protocol is https://


6. Open a command prompt window (cmd.exe) running as administrator.
   To do this, right-click on the Start menu entry and select Run as administrator:
   

7. Run the following command, replacing the URL with the Owin.Urls value from step 5:

   netsh http add urlacl url="https://*:443/" user="NT SERVICE\RedGate.SQLLighthouse.WebServer"

8. Open Windows Services (services.msc) and restart the DLM Dashboard Web Server service (Right-click on the service and choose Restart).

Once the DLM Dashboard Web Server has restarted, you can access DLM Dashboard using HTTPS on the hostname and port you specified.