Tidal Enterprise Scheduler: MSSQL Adapter Support for MSSQL 2008 Windows Authentication

Available Languages

Updated:November 4, 2011
Document ID:113191

Bias-Free Language

The documentation set for this product strives to use bias-free language. For the purposes of this documentation set, bias-free is defined as language that does not imply discrimination based on age, disability, gender, racial identity, ethnic identity, sexual orientation, socioeconomic status, and intersectionality. Exceptions may be present in the documentation due to language that is hardcoded in the user interfaces of the product software, language used based on RFP documentation, or language that is used by a referenced third-party product. Learn more about how Cisco is using Inclusive Language.

Introduction

The Tidal Enterprise Scheduler MSSQL Adapter has been enhanced to support Windows authentication (support limited to MSSQL 2008) in addition to previously supported SQL Server authentication.

This document describes how to resolve the “Unable to load jtds JDBC driver to connect Microsoft SQL Server to support Windows Authentication” error message when using Windows authentication for the Tidal Enterprise Scheduler MSSQL Adapter.

Prerequisites

Requirements

The minimum requirements are Tidal Enterprise Scheduler versions 5.3.1 and MSSQL 2008 database.

Components Used

The information in this document is based on the Tidal Enterprise Scheduler versions 5.3.1 or later.

The information in this document was created from the devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If your network is live, make sure that you understand the potential impact of any command.

Conventions

Refer to Cisco Technical Tips Conventions for more information on document conventions.

Solution

The jTDS JDBC driver is used to support Windows authentication. Download this free driver from http://jtds.sourceforge.net.

Complete these steps in order to apply the driver:

  1. Stop the Master.

  2. Copy the jTDS JDBC driver to {TIDAL_HOME}/services/{CAFA6E81-E29F-4263-8E80-4928FFF416A2}/lib.

  3. Restart the Master.

Related Information

Was this Document Helpful?

FeedbackFeedback

Contact Cisco