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:
- Open Windows Services
- Is there a service listed call "SQL Server (GOLIATHSQL)"?
- If not, then SQL Express failed to install, see the appropriate section below for steps to manually install SQL Express
- 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
- Reboot the Goliath Server (we have seen issues with trying to install SQL twice in a row)
- Confirm you are signed into the Goliath machine as a local or domain admin
- Open Windows Services and stop the MonitorIT Server Service
- Navigate to the install directory of Goliath
- The default path is "C:\Program Files (x86)\MonitorIT"
- Go to the "MSINSTALLS_X2017" folder
- Then go into the "SQL2017ExpressInstallFilesX64" folder
- Inside the folder launch "setup.exe"
- A new window will appear, choose the option for "New SQL Server stand-alone installation...."
- The setup screen will appear, run through the screens as prompted. It is important to configure the following when prompted:
- On the "Instance Configuration" page, change the SQL Instance or Named Instance form "SQLExpress" to "GoliathSQL"
- On the "Database Engine Configuration" page, add "system" to the SQL admins
- On the "Instance Configuration" page, change the SQL Instance or Named Instance form "SQLExpress" to "GoliathSQL"
- From there, finish out the installation of SQL Express
- When finished, run the Goliath Desktop icon as administrator to launch the technology
- If you are still seeing the database configuration error please move on to the next section
Steps to Resolve Permissions Issue
- Confirm you are signed into the Goliath machine as a local or domain admin
- Open Windows Services and stop the MonitorIT Server Service
- Navigate to the install directory of Goliath
- The default path is "C:\Program Files (x86)\MonitorIT"
- Go to the "Database" folder
- Copy the file named "MonitorIT.mdf"
- Navigate to "C:\Program Files\Microsoft SQL Server\MSSQL14.GOLIATHSQL\MSSQL\DATA"
- Paste the "MonitorIT.mdf" file here
- From Windows Administrative Tools, run "ODBC Data Source (32-bit)"
- Once it is open, click on the "System DSN" tab
- On this tab, you will see 2 entries, select the one for "BreakoutRPM" and click configure
- 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.
- Click Next once more, then finish. Click "Test Data Source.." button to confirm the attachment completed as expected and then click ok to close
- Navigate to the install directory of Goliath
- The default path is "C:\Program Files (x86)\MonitorIT"
- Go to the "Bin" folder and launch the "MonitorITCFU.exe" as admin
- Fill out the following information:
- The path to the MonitorIT Folder
- The default path is "C:\Program Files (x86)\MonitorIT"
- The server IP Address
- The web console port = 47629
- The agent port = 8282
- The path to the MonitorIT Folder
- Do a File>Save As and name the file "Default" and save it in the Bin folder
- Start the MonitorIT Server Service and after a few minutes try launching the technology.