Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco Workload Automation 6.3
  5. User Guide

Cisco Cisco Workload Automation 6.3 User Guide

Download
Page of 42
9
Cisco Systems, Inc.
www.cisco.com
2
Configuring the Microsoft SQL Server 
Adapter
Overview
The Microsoft SQL Server adapter software is already installed as part of a normal installation of CWA. However, you 
must perform the following steps to license and configure the adapter before you can run Microsoft SQL jobs:
 – Create a security policy to assign to the users that will run Microsoft SQL 
jobs. You may want to create different security policies to differentiate between users who just run Microsoft SQL 
jobs versus users who can run and edit Microsoft SQL jobs.
 – License the connection(s) to the Microsoft SQL instance. You cannot define a Microsoft SQL 
connection until you have applied the Microsoft SQL license from Cisco.
 – Create one or more user definitions in CWA with access to the 
Microsoft SQL instance using Microsoft SQL user names and passwords provided by the Microsoft SQL 
administrator. Users in CWA are authorized to run Microsoft SQL jobs on behalf of these Microsoft SQL runtime 
users.
 – Define a Microsoft SQL connection so the master can communicate 
with the Microsoft SQL instance. 
See also 
 for information about general and adapter-specific properties that can be set to 
control things like logging and connection properties.