Installs to a Windows device. An instance of SQL Server Express will be installed. The installer will install SQL Express, then deploy SQLBeat's source code (sprocs and functions and jobs and scripts), then install SQLFreeAgent. SQL Server will run using SQL Credentials. The SA password is "sqlbeat2024". Then, the installer will open a .SQL file for you with pre-coded configuration statements so that you can set up your first servers to be monitored. Or, You can install yourself. Troubleshooting If you already have a version of SQL Server installed on the target device, the installer may encounter issues due to version conflicts - isn't SQL fun! If you encounter this issue, all versions of the application "Microsoft OLE DB Driver for SQL Server" must be removed before installation of SQLBeat. If the SQL install step fails, you will need to delete the C:\SQLBEAT\SQLServer folder and all its subfolders before attempting to reinstall.

Installation

Installing SQLBeat

Create credentials

For SQL Services

For SQLBeat to connect to SQL boxes

Install a stand-alone MS-SQL instance

Configure necessary firewall rules

Deploy NOTIFICATION database

Deploy CONFIGURATION database

Deploy AUDIT database

Deploy WEBLOGS database

Deploy SHARED folder

Deploy JOBS

Apply SQL configuration options

Apply SQLBeat SQL alias

Add SQL logins

SQLBeat configuration options

Configure a server to be monitored

Confirm monitoring is working

Confirm emailing is working

Create an alerting recipient and rules