This article will assist you in connecting to an instance of SQL Server and get you monitoring the SQL Agent in that instance quickly. There are multiple ways to connect to a SQL instance with SQL Agent Insight…
- Click on the New Insight button in the toolbar.
- Double-click on an Available SQL Server detected via enumeration.
- Double-click on a Recently Connected Server.
- Select New Insight… from the File menu.
Depending on the action taken, the Server as it appears in the Connect to SQL Server dialog can be automatically populated. The option to manually enter a server/instance name is always available, just start typing when the focus is in the dropdown.
When entering a SQL instance manually, ensure to follow SQL Server instance naming conventions. Additionally, if your SQL Server instance requires a specific port, it can be included after the instance name, separated by a comma.
The Connect to SQL Server dropdown will always contain any instances of SQL that have been enumerated.
Post server/instance selection, toggle Windows Authentication on or off. Turning off Windows authentication will enable the SQL User and SQL Password textboxes for entry.
* Note: at the time of this writing, if using SQL authentication, the user account must have sysadmin privileges within the SQL instance.
The option to Start Insight in Maintenance Mode when enabled has the following benefits:
- All metrics immediately go into a state of maintenance.
- No new alerts for this instance will appear in the dashboard.
- If email notifications are enabled, nothing is sent.
- No warning or critical logging of threshold breaches within the Insight log.
Pro Tip: Enable Start Insight in Maintenance Mode until you have configured all of the individual metric thresholds to prevent unnecessary Insight logging and email notifications.
Pro Tip: Starting all Insights in maintenance mode automatically can be enabled in SQL Agent Insight’s Preferences.
When all options are set satisfactorily, click on the Test Connection button (1). Passing all actions successfully will enable the Open Insight button (2).
In some cases, not all actions will pass verification, as indicated by the red margin of the action that failed (1), and by the Open Insight button being disabled. To see further information regarding any errors during verification, click on the Errors tab (2). You should correct any issues identified, and click on the Test Connection button when resolved.