Cisco Cisco Workload Automation 6.3 User Guide

Configuring the Microsoft SQL Server Adapter

Define a Microsoft SQL Connection

A job cannot run on an adapter if its connection is disabled. If jobs try to run on a disabled connection, the job enters 
Agent Disabled status. Jobs already running on an agent that is disabled (or if the connection to the agent is lost) 
run to completion; however, their completion status is not returned until the agent is enabled.



 – Select to use the connection as your default connection when setting up future 

Microsoft SQL jobs. 



 – This tab designates a job limit and default runtime user.



 – This tab provides information to connect to the designated Microsoft SQL instance.



 – This tab provides configuration options for accessing the Microsoft SQL instance.



 – This tab describes the connection and provides a convenient place for notes about its purpose and 

use.

Adding a Microsoft SQL Connection

Modifying an adapters connection configuration should only be done when there are no jobs running that utilize 

the adapter connection. If the connection is created while jobs are active, the jobs may go into an orphan state.

From the 

 pane, select 

to display the 

 pane.

Click the 

 button or right-click and select 

 from the context menu to display 

the 

 dialog.

Enter a name for the new connection in the 

 field.

In the 

 field of the 

 tab, select the maximum number of concurrent active processes that CWA 

should submit to this Microsoft SQL instance and/or database at one time.

Optionally, in the 

list, select the name of a default user for Microsoft SQL jobs.

Only users that have been defined with Microsoft SQL passwords display in this list. The user selected is 
automatically supplied as the runtime user in CWA Microsoft SQL job definitions.

Click the 

 tab.