ManageEngine® SQLDBManager Plus


New Monitors

<< Prev

Home

Next >>

 

Add SQL DB Servers

 

Database servers are robust, enterprise-class database management system. SQLDBManager Plus provides database server monitoring that monitors database resources. This database server monitoring involves connecting to the database resource, collecting data, and representing its attribute details as graphs.


There are three ways of adding SQL DB monitors:

Discover via Network

  1. Click on Add SQL Server and then select Discover from Network link.


  2. SQLDBManager Plus automatically discovers the list of SQL Server(s) that are running in your network and displays them. Select the SQL Server(s) that you need to monitor by checking the check box beside each SQL Server(s).


  3. Enter the Port number on which the MS SQL Server is running.


  4. Enter the Polling interval time in minutes.


  5. Provide the User Name and Password of user who has permission to access the MS SQL database. The user name specified for collecting the data from MS SQL Server should have either System Administrator role or the user should be the DB owner for master database. Alternatively, you can provide the Windows Authentication details (give the User Name like domainname\username) also.


  6. If you are using Named Instance, then select Connect Using Named Instance. Then provided the proper instance name in the box below titled Instance Name.


  7. If you would like to monitor the host on which your SQL server is running, then select Collect Host Details. Provide proper authentication (Username and Password) for the host machine.


  8. Click Add Monitor(s). This then adds the selected MS SQL database server from the network and starts monitoring them.

 

Top

 

Add SQL Server Manually

  1. Click on Add SQL Server and then select Add SQL Server Manually link.


  2. Enter the Hostname / IP Address of the host.


  3. Enter the Port number in which the MS SQL is running.


  4. Enter the Polling interval time in minutes.


  5. Select the authentication type from the drop-down menu. If you select the SQL Server Authentication, provide the User Name and Password for the SQL server.


  6. If you select Windows Authentication, provide the Windows authentication details as Domainname\Username and Password for the same.


  7. If you are using Named Instance, then select Connect Using Named Instance. Then provided the proper instance name in the box below titled Instance Name.


  8. If you would like to monitor the host on which your SQL server is running, then select Collect Host Details. Provide proper authentication (Username and Password) for the host machine.


  9. Click Add Monitor(s). This then adds the MS SQL database server and starts monitoring them.

Top

Import from CSV

  1. Click on Add SQL Server and then select Import from CSV link.


  2. Click Browse, locate the CSV import file in your hard disk and then select the file. Then click Next.


  3. Once the upload is successful, you will see the following message:

    The file has been uploaded to the SQLDBManager Plus Machine in the location <Product-Home>\working\bulkadd\<Import File Name>.csv. This file will be deleted once discovery has been scheduled.

    You will also see the list of SQL server monitors added along with their DisplayName, HostName, SubNetMask, Port, UserName, Password, InstanceName and PollInterval information.

    Note: Refer to sample CSV Import file for more info.


  4. Click on Start Discovery button to add the SQL server for monitoring.


Top

 



<< Prev

Home

Next >>

Admin Activities

Bulk Configuration