ManageEngine® SQLDBManager Plus
Discover SQL Server through Network
Click on Add SQL Server and then select Discover from Network link.
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).
Enter the Port number on which the MS SQL Server is running.
Enter the Polling interval time in minutes.
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.
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.
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.
Click Add Monitor(s). This then adds the selected MS SQL database server from the network and starts monitoring them.