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:

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

Image 3538

Agent SQL Server

Is this article helpful for you?