Issue:

Upon installation of Goliath Performance Monitor, when trying to launch the technology the following error is displayed

Resolution:

When this error occur it is usually due to one or multiple of the following reasons:

• SQL Express Failed to install (blocked by GPO, permissions issue, no internet access, etc)
• Permissions issue attaching the Goliath database file

To identify the issue please follow the below steps:

1. Open Windows Services
2. Is there a service listed call "SQL Server (GOLIATHSQL)"?
   1. If not, then SQL Express failed to install, see the appropriate section below for steps to manually install SQL Express
   2. If yes, then it is likely a permissions issue with attaching the database file, see the appropriate section below for steps to resolve the permissions issue

Steps to manually install SQL Express

1. Reboot the Goliath Server (we have seen issues with trying to install SQL twice in a row)
2. Confirm you are signed into the Goliath machine as a local or domain admin
3. Open Windows Services and stop the MonitorIT Server Service
4. Navigate to the install directory of Goliath
   1. The default path is "C:\Program Files (x86)\MonitorIT"
5. Go to the "MSINSTALLS_X2017" folder
6. Then go into the "SQL2017ExpressInstallFilesX64" folder
7. Inside the folder launch "setup.exe"
8. A new window will appear, choose the option for "New SQL Server stand-alone installation...."
9. The setup screen will appear, run through the screens as prompted. It is important to configure the following when prompted:
   1. On the "Instance Configuration" page, change the SQL Instance or Named Instance form "SQLExpress" to "GoliathSQL"
   2. On the "Database Engine Configuration" page, add "system" to the SQL admins
10. From there, finish out the installation of SQL Express
11. When finished, run the Goliath Desktop icon as administrator to launch the technology
12. If you are still seeing the database configuration error please move on to the next section

Steps to Resolve Permissions Issue

1. Confirm you are signed into the Goliath machine as a local or domain admin
2. Open Windows Services and stop the MonitorIT Server Service
3. Navigate to the install directory of Goliath
   1. The default path is "C:\Program Files (x86)\MonitorIT"
4. Go to the "Database" folder
5. Copy the file named "MonitorIT.mdf"
6. Navigate to "C:\Program Files\Microsoft SQL Server\MSSQL14.GOLIATHSQL\MSSQL\DATA"
7. Paste the "MonitorIT.mdf" file here
8. From Windows Administrative Tools, run "ODBC Data Source (32-bit)"
9. Once it is open, click on the "System DSN" tab
10. On this tab, you will see 2 entries, select the one for "BreakoutRPM" and click configure
11. Click the next button twice until you come to a screen like the below. Modify the "attach database filename" path to match the new location. 
12. Click Next once more, then finish. Click "Test Data Source.." button to confirm the attachment completed as expected and then click ok to close
13. Navigate to the install directory of Goliath
    1. The default path is "C:\Program Files (x86)\MonitorIT"
14. Go to the "Bin" folder and launch the "MonitorITCFU.exe" as admin
15. Fill out the following information:
    1. The path to the MonitorIT Folder
       1. The default path is "C:\Program Files (x86)\MonitorIT"
    2. The server IP Address
    3. The web console port = 47629
    4. The agent port = 8282
16. Do a File>Save As and name the file "Default" and save it in the Bin folder
17. Start the MonitorIT Server Service and after a few minutes try launching the technology.