ManageEngine® SQLDBManager Plus
Prerequisites for Monitoring SQL Servers
To monitor a SQL Server, you need to specify a SQL user with these Minimum User Privileges :
Role : public and sysadmin (if you want to monitor Database VLFs)
Database : master
DB role : db_datareader
Database : msdb
DB role : SQLAgentReaderRole
View server state : Grant
Note : To grant VIEW SERVER STATE permission, you can use any of the following methods.
Execute the following query : GRANT VIEW SERVER STATE TO username; In SQL management studio for user choose Properties -> Securables -> Click Add (under securables) -> choose "All objects of the Types..." -> choose Servers -> choose Grant for "View server state" permission
Execute the following query : GRANT VIEW SERVER STATE TO username;
In SQL management studio for user choose Properties -> Securables -> Click Add (under securables) -> choose "All objects of the Types..." -> choose Servers -> choose Grant for "View server state" permission
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 :
Port 135 for Remote Procedure Call (RPC): When you execute the following command, you should get a blank screen from the machine on which SQLDBManager Plus is running.
Similarly, you should get a blank screen when you execute the following command from the target machine :
Port 445 for Windows Management Instrumentation (WMI): WMI will use DCOM for remote communication and while communicating through DCOM, the target server (the server which is to be monitored by SQLDBManager Plus) by default will use any random port above 1024. You have to connect to the target server and configure it to using a port within the specified range of ports.
You can follow the steps mentioned in this link :
http://support.microsoft.com/kb/300083 for restricting the ports in the target server (click on the link to learn how to configure
for Windows 2003 server).
Note: You must specify at least 5 ports in this range for target server (you are normally recommended to open at least 100 ports - http://support.microsoft.com/kb/217351/EN-US/). This same range ports must be also opened in the firewall.