SQL Agent Insights:Documentation:Connecting to an Instance
Applies to: Error creating thumbnail: Unable to save thumbnail to destination SQL Agent Insight (all supported versions unless otherwise noted)
Connecting to an Instance of SQL Server®
This article will assist in connecting to an instance of SQL Server to start monitoring the SQL Agent in that instance quickly. There are multiple ways to connect to a SQL Server instance with SQL Agent Insight, including:
- Clicking on the New Insight button in the toolbar,
- Selecting New Insight… from the File menu,
- Double-clicking a server name from the list of Available SQL Servers, post enumeration,
- Double-clicking a server name from the list of Previously Connected Servers, or,
- Pressing the key sequence, CTRL+N
Depending on the action taken above, the server as it appears in the Connect to SQL Server dialog can be automatically populated.
NOTE |
The option to manually enter a server / instance name is always available; just start typing when the focus is in the Server dropdown menu of the Connection dialog. A successful connection will place that SQL instance into the Previously Connected Instances pane for quicker connections in the future. |
When entering a SQL server instance name manually, ensure to follow SQL Server instance naming conventions. Additionally, if the 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. |
Microsoft®, Windows® and SQL Server® are registered trademarks of Microsoft Corporation in the United States and/or other countries.
Some icons courtesy of Icons8