Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

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

Tags

Classifications

Public