SQL Server Agent
Overview
A SQL Server agent encapsulates the connection details to a single instance of Microsoft SQL Server.
Operational Considerations
An incorrectly configured SQL Server agent will affect every Operation attached to it. When configuring this agent, it is important to keep in mind:
- Whether the target Windows SQL Server uses Windows or SQL Authentication.
- Required priveleges of the user connection details to perform desired functions.
- SQL operation types supported by the database.
- Connection timeout limits of the target SQL server.
Usages
The SQL Server agent is used by the following Operations:
- Database Execute Query operation
- Database Query Changes operation
Configuration
In addition to the common agent configuration settings shared by all agents, the SQL Server agent requires the following by way of configuration:
| Name | Description | Standard Configuration |
|---|---|---|
| Connection String | An ADO.NET connection string to be used when connecting to the SQL database. This field allows configuration for a non-typical connection to a SQL Server database. | False |
| Server | Full name of the server being connected to. | True |
| Database name | Name of target database. | True |
| Authentication Type | Whether to use Windows or SQL Authentication on connection to the target server. | True |
| Username | Username to authenticate to the database with (Only required with SQL Authentication). | True |
| Password | Password to authenticate to the database with (Only required with SQL Authentication). | True |
Customer support service by UserEcho
