SQL
Connections
Description
Allows you to create/configure a SQL connection for use on any connected Agent. A SQL connection is a string that contains the information needed to access a database. Once configured, the pre-defined SQL connection can be called from any Open SQL Connection step of any task.
To access the SQL Connections settings, select Options on the Server Management Console's navigation bar, and then select Settings > Server Settings > SQL Connections.
Parameters
The following table displays the available SQL Connection preferences:
| Property | Description |
|---|---|
| Name | The user defined name of the SQL connection. This value corresponds to the Session Name parameter found in the properties of the Open SQL Connection action. |
| Value | The connection string to set as the pre-defined SQL connection. Click the Build button to open the Data Link Properties dialog allowing you to build a proper connection. |
| Comment | A user-defined comment describing the SQL connection. Entering a comment is optional. |
| Enabled | Specifies whether the connection is enabled or disabled (all new connections are enabled by default). |
SQL connections management
To create a predefined SQL connection
- On the SQL Connections window, select New.
-
In the Name box , enter a name for the SQL connection.
-
For Value, select Build Connection. This opens a Data Link Properties dialog for configuring connection strings to data sources. For more information, see Data Link Properties.
-
In the Comment box, optionally enter a description for the SQL connection.
-
Select OK.
To modify an existing SQL connection
-
On the SQL Connections window, select a connection from the list, and then select Modify.
-
Make your desired changes to the connection, and then select OK.
To remove an existing SQL connection
On the SQL Connections window, select a connection from the list, and then select Remove.