Comment on page
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.
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. Clickfor 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
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