Microsoft SQL Server

How to Configure Remote Monitoring of Microsoft SQL Server

1. In the IT-Conductor main menu, navigate to Dashboards > Administrator.

Figure 1: IT-Conductor Dashboards Menu

2. In the Administrator dashboard, locate the Microsoft SQL Servers panel and click the to start adding a system to be monitored.

Figure 2: Add Microsoft SQL Servers

3. In the Create New Microsoft SQL Server wizard, fill out all the necessary information. Once completed, click to add the system.

Note Please specify the MSSQL Server name in the DBA Connection Property field, use <host name>:<port> notation with the port typically set to 1433.

Figure 3: Create New Microsoft SQL Server

4. A pop-up message will confirm that the Microsoft SQL has been added successfully. Click OK to dismiss and proceed to configure the Microsoft SQL user to be used for monitoring.

Figure 4: Microsoft SQL Server Created Successfully

5. Provide the account information in the wizard, then click to complete the configuration.

Note Please take note of the Microsoft SQL Monitoring configuration requirements

Figure 5: Microsoft SQL Account Information

6. A pop-up message will confirm that the account has been created successfully. Click OK to complete the process.

Figure 6: Microsoft SQL Account Confirmation

7. The newly added system will appear in the Microsoft SQL Servers panel

Figure 7: Microsoft SQL Server with Ready Status

Note It may take a few minutes to change the status to "In Progress," refresh the panel if needed. If there are issues with the configuration, such as wrong connection parameters or an invalid account etc. the status will stay "Ready", troubleshoot by displaying the log. Click for the new record or click object icon and select Log from the menu popup.

8. The SQL Server will show up in the service grid within 5-15 minutes

Figure 9: IT-Conductor Service Grid View

IT-Conductor Microsoft SQL Server Monitoring Configuration Requirements

The account used to monitor the SQL Server instance should have the following permissions:

• Member of the "sysadmin" role

If you are unable to grant "sysadmin" permissions to the account, please grant the following permissions:

• Member of the "db_datareader" role on the msdb system database

• Member of "SQLAgentReader" role on the msdb system database

• VIEW ANY DEFINITION server permission

• ALTER TRACE server permission (if you want to enable trace data)

• VIEW SERVER STATE and VIEW DATABASE STATE database permissions on all databases

• Member of the db_owner role on the "tempdb" database

• EXECUTE on xp_readerrorlog