Microsoft SQL Server

Configure Remote Monitoring of Microsoft SQL Server

1. Navigate to Dashboards → Administrator.

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

Figure 1: Adding 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 2: Creating New 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 3: 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 account requirements when configuring the monitoring account.

Figure 4: Creating New Account

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

Figure 5: Microsoft SQL Account Confirmation

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

Figure 6: Microsoft SQL Server with Ready Status

Note: It may take a few minutes for the status to change to "In Progress." Refresh the panel if needed. If there are configuration issues, such as incorrect connection parameters or an invalid account, the status will remain "Ready". Troubleshoot by displaying the log. Click for the new record, or click the object icon and select Log from the pop-up menu.

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

Figure 7: SQL Servers in IT-Conductor Service Grid

Account 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