📦 Delivery Package

Once your order is fulfilled, you will receive the following components necessary to deploy the system:

• Two Microsoft SQL Server databases:
  • MaintDB – install this database on every server you want to monitor.
  • AdminDB – install this database on your central administration server only.
• Web application files – for deploying the monitoring dashboard in IIS.
• Login credentials – administrator credentials for initial login and setup.

⚙️ System Requirements

1. SQL Server Requirements

• Microsoft SQL Server version 2022 or later must be installed.
• Each server should have at least:
  • 8 GB RAM (working memory)
  • 20 GB of free disk space
  • Quad-core processor (4 logical CPU cores)
• You must have a SQL Server login with sysadmin privileges.
• Only Standard or Enterprise editions are supported.
• MaintDB must be deployed on each monitored server.
• AdminDB should be deployed only on your central admin server.

2. Web Server (IIS) Requirements

• Windows Server with Internet Information Services (IIS) 10 or later.
• Recommended to install on a separate server than SQL Server for performance.
• The following components must be installed:
  • .NET 9 Runtime
  • .NET 9 ASP.NET Core Hosting Bundle
  • AspNetCoreModuleV2 must be properly registered
• The site must be configured for HTTPS using a valid SSL certificate (self-signed is acceptable).

3. Database Initialization

1. Copy the MaintDB and AdminDB databases to their appropriate servers.
2. Open SQL Server Management Studio (SSMS) and connect with a sysadmin user.
3. Execute the following procedure on each MaintDB database:

   EXEC INIT_ALL;

4. This procedure will automatically create necessary jobs, permissions, and structures.

4. First Login & Configuration

• Navigate to the deployed WebApp URL using HTTPS.
• Login using the administrator credentials provided in the package.
• Within the interface, you can:
  • Register monitored SQL Servers
  • View real-time and historical data
  • Create and manage users and permissions
  • Add or remove servers from monitoring
• Note: You must initialize MaintDB on any server before it can be added to the system.

5. Adding More Servers Later

1. Copy MaintDB to the new SQL Server instance.
2. Connect using SSMS as a sysadmin and execute INIT_ALL procedure.
3. Add the server from the WebApp interface.

6. Firewall Configuration

• Ensure the following network ports are open:
  • Port 443 – for secure HTTPS access to the WebApp
  • Port 1433 – for SQL Server access (or your custom port if configured differently)
• Configure firewalls to allow communication between WebApp, admin server, and monitored servers.

---

📬 Need Support?

If you have any questions, don’t hesitate to contact us via our website.