SQL Server

Pre-requisites

Check the supported versions

DBmarlin supports most versions of SQL Server from 2014 and above. Please check the list of supported platforms before continuing and contact us if you are not sure.

Create a monitoring user with the correct permissions

Before adding a target MS SQL Server instance in the UI you should first create a dbmarlin user in the target database instance. This needs to be a SQL Server authenticated account (Windows Authentication not currently supported).

CREATE LOGIN dbmarlin WITH PASSWORD = 'securepassword';
CREATE USER dbmarlin for login dbmarlin;
use master
EXEC sp_addsrvrolemember 'dbmarlin', 'sysadmin';
GO

Adding the Database Target

This is done through the User Interface using the Add Database screen