This article is in reference to Microsoft SQL Express which is commonly used during Proof Of Concepts (POCs). Upon installation of Goliath Performance Monitor, when trying to launch the technology the following error is displayed
How to tell if SQL Express Failed
- When you launch the product for the first time and the webpage wont load. Sometimes a Database error pop-up will appear.
- Open Windows Services and see if there is a service named “SQL Server (Goliath SQL)”, if there is not SQL Express failed to install
How to Resolve
- Stop the MonitorIT Server Service
- Open Windows File explorer and go to “C:\Program Files (x86)\MonitorIT\MSINSTALLS_X2017\SQL2017ExpressInstallFilesx64” and run “setup.exe”
- Once the SQL Install window opens, choose the first option for “New SQL Server…”
- Next through the installer changing the following settings
- On the “Instance Configuration” page, set the database name to “GoliathSQL”
- On the “Database Engine Configuration” page add the “system” account to the SQL Server Administrators
- On the “Instance Configuration” page, set the database name to “GoliathSQL”
- Complete the installer and Launch 'ODBC Data Sources (32-bit)'from Windows Administrative Tools
- When 'ODBC Data Sources (32-bit)' launches, by default it will be on the'User DSN' tab. Switch to the 'System DSN' tab
- Click 'Add' and scroll through the list to select 'SQL Server Native Client 11.0' then hit 'Finish'
- Complete the requested information as highlighted below and then choose 'Next'
- Name: BreakoutRPM
- Description: this can be anything you like
- Server: (local)\GoliathSQL
- Keep all default settings on the "How should SQL Server verify..."page and click 'Next'
- Check the box to enable 'Change the default database to:' and set it to “MonitorIT”
- Check the box for “attach database as filename” and enter “C:\Program Files (x86)\MonitorIT\Database\MonitorIT.mdf”
- Keep all default setting on the following page and click 'Finish'
- A SQL Server Setup window will appear. Click the 'Test Data Source...'button to confirm the SQL Connection is successful. Then click 'OK' to save the configuration.
- If the test is not successful and you see a “CREATE FILE” error do the following:
- Save this configuration
- Copy the database file located at “C:\Program Files (x86)\MonitorIT\Database\MonitorIT.mdf” and paste it in “C:\Program Files\Microsoft SQL Server\MSSQL14.GOLIATHSQL\MSSQL\DATA” folder
- Reopen the ODBC entry you just created, and next through until you get to the page where the database name and path is configured
- Update the “attach file” path to be “C:\Program Files\Microsoft SQL Server\MSSQL14.GOLIATHSQL\MSSQL\DATA\MonitorIT.mdf”
- Test the database source again and it should be successful
- Start the MonitorIT Server Service and wait about 2-3 mins