AlertMailService Installer

A combined Windows installer for the MailAlertServer and MailRequestServer services, built with Inno Setup.

About

MailAlertServer monitors SQL Server database conditions on a configurable interval and triggers email alerts when conditions are met.

MailRequestServer processes queued email requests from a database table and sends them via SMTP.

Both services share a common SQL Server database and are installed together as Windows services by this installer.

Prerequisites

Build Machine (Windows)

• Git for Windows
• .NET 8.0 SDK
• Inno Setup 6

Target Machine (where the installer runs)

• .NET 8.0 Runtime (Windows x64)
• SQL Server instance (local or remote)
• sqlcmd - included with SQL Server or the ODBC Driver for SQL Server

Quick Start

git clone git@github.com:dhunt84971/AlertMailServiceInstaller.git
cd AlertMailServiceInstaller
build.bat

The installer will be output to Output\AlertMailServiceSetup.exe.

See BUILD_INSTRUCTIONS.md for detailed manual build steps and troubleshooting.

What the Installer Does

During installation, the user is prompted for:

1. SQL Server instance name
2. Authentication method (Windows or SQL Server)
3. Administrator credentials (for database setup)
4. Database name
5. Application database credentials (created automatically)
6. SMTP server settings
7. Alert check interval

The installer then automatically:

• Creates the database and tables if they don't exist
• Creates a SQL Server login and database user for the application
• Inserts SMTP configuration into the database
• Writes config files for both services
• Registers and starts both Windows services

Project Structure

AlertMailServiceInstaller/
├── build.bat              # Automated build script
├── setup.iss              # Inno Setup installer script
├── setup_db.sql           # Database setup SQL script
├── BUILD_INSTRUCTIONS.md  # Detailed build documentation
├── LICENSE                # MIT License
└── README.md              # This file

License

This project is licensed under the MIT License - see the LICENSE file for details.