Cisco Cisco Identity Services Engine Software Manual Técnica

Contents

Introduction

Prerequisites

Requirements

Components Used

Configure

Step 1. MS SQL Basic Configuration

Step 2. ISE Basic Configuration

Step 3. Configure User Authentication

Step 4. Configure Group Retrieval

Step 5. Configure Attributes Retrieval

Troubleshoot

Introduction

This document describes how to configure Identity Services Engine (ISE) with Microsoft Standard
Query Language (SQL) Server for ISE authentication using

Note: Open Database Connectivity (ODBC) authentication requires ISE to be able to fetch a
plain text user password. The password can be encrypted in the database, but has to be
decrypted by the stored procedure.

Prerequisites

Requirements

Cisco recommends that you have knowledge of these topics:

Database and ODBC concepts

●

Microsoft SQL Server

●

Components Used

The information in this document is based on these software and hardware versions:

Identity Services Engine 2.1

●

MSSQL Server 2008 R2

●

Configure

Step 1. MS SQL Basic Configuration

Configuration steps include creating a database and one user for ISE with permissions to access