SQL Agent Insights:Documentation:Connecting to an Instance: Difference between revisions
| Line 11: | Line 11: | ||
Depending on the action taken above, the server as it appears in the Connect to SQL Server dialog can be automatically populated. | Depending on the action taken above, the server as it appears in the Connect to SQL Server dialog can be automatically populated. | ||
{| style="background-color:#E7F5FE;border-style: solid; border-width: 1px; border-color:blue" cellpadding="3" | |||
|- style="color:blue;" | |||
| '''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. | |||
|| [[File:manual-connection.png|frameless|none]] | |||
|- | |||
|} | |||
<hr> | <hr> | ||
Revision as of 01:56, 3 February 2023
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