Analysis of your IT infrastructure

Home
Supervision incidents management Reporting services Data management Inventories
Monitorpack Guard Monitorpack Discovery Monitorpack Snmp
Pricing & subscriptions Open a ticket Online support
Downloads Enterprise Contact ☰


knowledge base










Local or cloud SQL Express database

Monitorpack is provided free of charge and maintains the versions of its databases that it makes available to you for download. These tables allow the consolidation of alarms generated by the Monitorpack Guard and Monitorpack SNMP modules, scripts and functions.

Note that this procedure only covers the scope of installation and configuration of the SQL Express server part, it does not include the reporting part that uses PowerBI Report Server that you can find in our downloads.

Install your SQL server by default in your Active Directory forest or use your existing SQL server, you can quite create your SQL server in standalone in a Workgroup, a DMZ, at AWS or any other SaaS provider as long as you can write from the Monitorpack Guard and/or SNMP server, which implies that ports 1433,1434, 80, 443 and (445 for authentication) must be accessible on the SQL server.

SQL Express deployment steps

  • Install a SQL Express server,

  • Configure the SQL server,

  • Create accounts,

  • Create the database,

  • Create the scheduled task (if Express version),

  • Add the connection information in Monitorpack Guard & Monitorpack SNMP.



To create the database 'Monitorpack_GuardReportsMonitorpack', open SQL Server Management Studio (SSMS) > click on Database > Right click > New database and name it 'Monitorpack_GuardReportsMonitorpack'

To create the tables in the database, using SQL Server Management Studio (SSMS), position yourself on the database that you have just created, then execute the script 'Monitorpack_GuardReportsMonitorpackExpress.sql' to create tables.

SQL Base

Download the 'SQLExpressMonitorpack.zip' file which will allow you to create the Monitorpack tables once you have first manually created the database on your SQL Express server.
File type Information Description Version Link
IT monitoring Zip file SQLExpressMonitorpack 2.0

Configuring Authentication Mode

Connect to the SQL EXPRESS server instance using SQL Server Management Studio (SSMS). Right-click the database instance and go to Properties.

On the Server Properties page, click the Security page. Click the radio button next to 'SQL Server and Windows Authentication Mode' and then click OK to close the Server Properties page.

Once you click the Ok button, you will need to restart the SQL Server service for this change to take effect. After restarting SQL Server, the authentication mode will be changed to SQL Server and Windows authentication mode.

Now go to SQL Server Configuration Manager and restart the 'SQL server(SQLEXPRESS)' service.

Configuring protocols

By default SQL Server listens on dynamic ports, it is relevant to freeze the default listening port which is commonly 1433.
1. SQL Server management open the console go to protocol for SQL Express open the properties go to the IP address tab force port 1433 in the fields (IP1 and All IP) apply and close.
2. Disable named pipes and shared memory
3. Restart the SQL Server and browser services so that the new configuration is taken into account.


Windows user account & permissions

Create an Active Directory or local (Workgroup) account named 'ReportsMonitorpack' to view the web portal. From the 'Computer Management' console, create a user 'ReportsMonitorpack' who is a member of the 'Users' group.

1. From the SQL Server Management Studio (SSMS) console, right-click on the Logins folder, search for and add the user 'ReportsMonitorpack'.

For the user to be able to see the reports in the web analytics portal, it is first necessary that this account has read and write rights on the database consulted through the Power BI report Server portal if you decide to deploy it (reporting part). Give it Read & Write rights on the 'Monitorpack_GuardReportsMonitorpack' database.

To give read and write rights on the database, go to the SQL Server Management Studio (SSMS) interface, open the 'Logins' folder > select the 'ReportsMonitorpack' account > right-click 'Property', choose the User Mapping page > Position yourself on the 'Monitorpack_GuardReportsMonitor' database > check db_datareader & db_datawriter.

SQL account & permissions

From the SQL Server Management Studio (SSMS) console, create the SQL account 'SQL_Monitorpack' (this is the account you will use to write in the database), Right-click on the Security folder > Logins > New login Select SQL server Authentication > create the account 'SQL_Monitorpack', disable 'Enforce password expiration', provide a password and validate the creation of the account.

To give read and write rights on the database, go to the SQL Server Management Studio (SSMS) interface, open the 'Logins' folder > select the SQL account 'SQL_Monitorpack' > right-click 'Property', choose the User Mapping page > Position yourself on the 'Monitorpack_GuardReportsMonitor' database > check db_datareader & db_datawriter.


This scheduled task is useful only in the case of the SQL Express version (which does not have stored procedure management), for other SQL versions, use the scripts in the stored procedures and schedule the execution time every 5 minutes.

Copy the Alarms folder that you downloaded, in the directory "C:\ScriptsMonitorpack\", With an administrator account or in 'run as administrator' mode execute the following command in a Windows command window.

schtasks /create /tn "Monitorpack Alarms Update" /tr "\"C:\ScriptsMonitorpack\Alarms\SQL_Alarms_Request_ReportsMonitorpack.bat"" /sc minute /mo 5