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\MonitorIT\MSINSTALLS_X2019\SQL2019ExpressInstallFilesX64” 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
- Open Windows File Explorer and navigate to the \MonitorIT\Database folder
- Default location is C:\Program Files\MonitorIT\Database
- Edit the file DatabaseVersioningTool.exe.config with the following settings and save once complete
- On line 4, replace the data source=localhost setting with data source=____ where the blank is the SQL Server and instance name of where the database resides
- For example, if your database resides at SQL\Test12 then it should be data source=SQL\Test12
- On line 4, replace the initial catalog=MonitorIT1 setting with initial catalog=____ where the blank is the name the database is going to be.
- For example, if you want the database name to GoliathDB then it should be initial catalog=GoliathDB
- On line 4, replace the data source=localhost setting with data source=____ where the blank is the SQL Server and instance name of where the database resides
- From Windows Files Explorer, within the \MonitorIT\Database folder go to File>Open Windows Powershell as administrator
- A Powershell console window will open, enter the command .\DatabaseVersioningTool.exe and click the enter key
- For this step, be sure that the account you are running this as has SQL Server sysadmin rights
- The Powershell console window will prompt you to Please Enter Go to Continue, type Go and hit the enter key to proceed
- The database will be created at the SQL Server mentioned
- If you get any errors back, please reference the migration.log file in the Database folder.
- More often then not the error is due to permissions or network connection. Feel free to open a support ticket for additional assistance if needed
- If you get any errors back, please reference the migration.log file in the Database folder.
- If all is successful, launch ODBC Data Sources (64-bit) from Windows Administrative Tools
- When ODBC Data Sources (64-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 ODBC Driver 18 for SQL Server 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 the database you just created
- 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.
O
- Start the MonitorIT Server Service and wait about 2-3 mins