ManageEngine® SQLDBManager Plus Prerequisites for SQL DB Manager | ||
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.
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
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 :
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.
Understanding SQL DB Manager |
Working with SQL DB Manager |