A SQL Server agent encapsulates the connection details to a single instance of Microsoft SQL Server.
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.
The SQL Server agent is used by the following Operations:
In addition to the common agent configuration settings shared by all agents, the SQL Server agent requires the following by way of 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