Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions
• What's Changed

1 Microsoft SQL Server Plug-in Overview and Prerequisites

• 1.1 Microsoft SQL Server Plug-in Overview and Feature Summary
• 1.2 What's New in This Release
  • 1.2.1 Added Support for Microsoft SQL Server 2014
  • 1.2.2 Updated User Interface
  • 1.2.3 Business Intelligence Publisher Reports
  • 1.2.4 Chargeback Functionality
  • 1.2.5 SQL Server Compliance Standard
• 1.3 Supported Versions
• 1.4 Prerequisites
• 1.5 Downloading the Plug-in
• 1.6 Deploying the Plug-in
• 1.7 Upgrading the Plug-in
• 1.8 Undeploying the Plug-in

2 Configure Microsoft SQL Server for Authentication

• 2.1 Enabling and Finding TCP/IP Port Information
  • 2.1.1 Enabling TCP/IP Port
  • 2.1.2 Finding the TCP/IP Port
• 2.2 Modifying the Permissions for Database Authentication
• 2.3 Enabling SQL Authentication or Mixed Authentication
• 2.4 Authentication Configuration Scenarios

3 Discovery of the Microsoft SQL Server Target

• 3.1 Discovering Targets
• 3.2 Adding Targets with EMCLI
• 3.3 Verifying and Validating the Plug-in

4 Configuring Connections

• 4.1 Configuring Remote Connections to Monitor Targets
• 4.2 Configuring Connections to Execute Jobs

5 Creating, Editing, and Using Jobs

• 5.1 Creating and Editing Jobs
• 5.2 Using the Backup and Restore Jobs

6 Using Reports and Monitoring Templates

• 6.1 Using the Microsoft SQL Server Plug-in Reports
• 6.2 Deploying Reports After BI Publisher is Configured
• 6.3 Using the Microsoft SQL Server Plug-in Monitoring Templates

7 Chargeback Functionality

• 7.1 About Chargeback
• 7.2 Chargeback Plug-in Deployment
• 7.3 Configuring Global Settings for Chargeback
• 7.4 Configuring a Charge Plan
• 7.5 Revising Extended Charge Plans
• 7.6 Configuring a Cost Center
• 7.7 Configuring an Entity
• 7.8 Generating and Distributing Chargeback Reports
• 7.9 Additional Information

8 Compliance Management

• 8.1 About Compliance Management
• 8.2 Managing Compliance Framework
• 8.3 Configuring the SQL Server Configuration Compliance Standard
• 8.4 "Create Like" Compliance Standard
• 8.5 Editing a Compliance Standard
• 8.6 Evaluating Compliance
• 8.7 Using Trend Overview
• 8.8 Using Compliance Reports
• 8.9 Managing Compliance Violations
• 8.10 Additional Information

9 Inventory and Usage Details

• 9.1 Inventory and Usage Details Page Feature Summary
• 9.2 Accessing the Inventory and Usage Details Page
• 9.3 Additional Information

Index