This article is in reference to Microsoft SQL Express which is commonly used during Proof Of Concepts (POCs).
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