Cisco Cisco Workload Automation 6.3 User Guide
7
Cisco Systems, Inc.
www.cisco.com
1
Introducing the
Microsoft SQL Server Adapter
This chapter provides an overview of the Microsoft SQL Server Adapter and its requirements:
Overview
The Microsoft SQL Server (MSSQL) adapter integrates Cisco Workload Automation (CWA) with MSSQL Server allowing
you to:
you to:
Create, schedule and run MSSQL queries and MSSQL Agent jobs through CWA.
Monitor events within a MSSQL database, including table, index, and row creation, modification and deletion.
The MSSQL Adapter supports running jobs under both Microsoft SQL Server 2000, 2005, 2008, and 2012. However,
event monitoring is supported on 2005, 2008 and 2012 only.
event monitoring is supported on 2005, 2008 and 2012 only.
If you are installing Microsoft SQL Server 2000 and 2005 on the same machine, you will need to have separate names
for each instance. Or, alternatively, you can assign each instance its own unique listening port. The default database port
is usually 1433.
for each instance. Or, alternatively, you can assign each instance its own unique listening port. The default database port
is usually 1433.
If you are using different versions of Microsoft SQL Server, it is a good idea to place all jobs under a SQL group. This way,
when switching between versions, you only need to switch the connection at the group level.
when switching between versions, you only need to switch the connection at the group level.
Prerequisites
Refer to your Cisco Workload Automation User Guide for a complete list of hardware and software prerequisites. These
sections describe the prerequisite Microsoft SQL Server user permissions and roles:
sections describe the prerequisite Microsoft SQL Server user permissions and roles:
Database Jobs
Creating, viewing and running database jobs requires a variety of permissions. The easiest way to accomplish this is to
assign the
assign the
sysadmin
role to your user.
To assign the sysadmin role and grant permissions:
1.
Run the following query to determine if your user is assigned the sysadmin role:
select is_srvrolemember('sysadmin')