Submit a ticketCall us

Announcing NCM 7.7
With NCM 7.7, you can examine the rules that make up an access control list for a Cisco ASA device. Then you can apply filters to display only rules that meet the specified criteria, order the rules by line number or by the hit count, and much more.
See new features and improvements.

Home > Success Center > Server & Application Monitor (SAM) > SQL credentials issue

SQL credentials issue

Overview

SQL User experience monitors are being marked as up but you're still get authentication failures on the target SQL server.

The SQL Server User Experience Monitor components by default attempt to login to the server using a SQL account first and then attempt a AD user. This shows you how to reverse the order so that you no longer get Audit Failures.

Environment

All SAM versions

Cause

The first attempt at verifying the credentials uses SQL authentication, which fails with Windows credentials. The second attempt uses Windows authentication and will succeed.

Resolution

Modify the template and/or application by checking the option named "Use Windows Authentication first, then SQL authentication" for all components.
sqlauth.png

 

Last modified
22:33, 30 Nov 2016

Tags

Classifications

Public