Documentation

Learn how to set up and get the most out of MIIDBA for your SQL Server monitoring.

Getting Started

To allow MIIDBA to monitor your SQL Server instances, you'll need to create a dedicated login with the appropriate permissions. Run the following SQL script on each target instance.

Permissions & Login Setup

The following script creates a dedicated MIIDBA login and grants the minimum required permissions for monitoring.

USE [master]
GO

CREATE LOGIN [MIIDBA] WITH PASSWORD=N'##PASSWORD##',
  DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF

CREATE USER [MIIDBA] FOR LOGIN [MIIDBA];

GRANT VIEW SERVER STATE TO [MIIDBA];

GRANT VIEW ANY DEFINITION TO [MIIDBA];

GRANT SELECT ALL USER SECURABLES TO [MIIDBA];

GRANT CONNECT ANY DATABASE TO [MIIDBA];

GRANT EXECUTE ON sys.xp_enumerrorlogs TO [MIIDBA];

GRANT ALTER ANY EVENT SESSION TO [MIIDBA];

USE [msdb]
GO

CREATE USER [MIIDBA] FOR LOGIN [MIIDBA];

GRANT EXECUTE ON [dbo].[agent_datetime] TO [MIIDBA];

ALTER ROLE [db_datareader] ADD MEMBER [MIIDBA]