ManageEngine® SQLDBManager Plus


Prerequisites for SQL DB Manager

<< Prev

Home

Next >>

 

Prerequisites for Monitoring SQL Servers

 

To monitor a SQL Server, you need to specify a SQL user with these Minimum User Privileges :


Server Roles

Role : public and sysadmin (if you want to monitor Database VLFs)


User Mapping

Database : master

DB role    : db_datareader

Database : msdb

DB role    : SQLAgentReaderRole


Securables

View server state : Grant


Note : To grant VIEW SERVER STATE permission, you can use any of the following methods.

Status

Permission to connect to database engine : Grant

Login : Grant


Also note that if you would like to monitor SQL Server using SQL instance name and/or if you would like to add SQL Servers through auto discovery, then you need to ensure that the 'SQL Browser Service' is running in the system.

 

If there is firewall enabled within the network, then the following ports must allowed through the firewall for monitoring Windows server hosting the Microsoft SQL :


<< Prev

Home

Next >>

Understanding SQL DB Manager

Working with SQL DB Manager