Submit a ticketCall us

WebinarDatabase Roundtable – Expert Database Professionals Feel Your Pain

In this video broadcast, Head Geek™ Tom LaRock is joined by Karen Lopez, Tim Chapman, and David Klee. They’ve known each other for many years, so this discussion was like four friends getting together to talk data and databases. They discussed diagnostic data collection, common performance root causes, reactive tuning versus proactive, and more. Join us for an engaging discussion on these topics! Plus, Tom LaRock will be available to answer your questions live.

Register now.

Home > Success Center > Server & Application Monitor (SAM) > SAM - Knowledgebase Articles > SQL Event log error: Login failed for user 'Domain\Username'

SQL Event log error: Login failed for user 'Domain\Username'

Overview

Recurring SQL Event log errors appear when the SQL User Experience Monitor is assigned to a node in Server & Application Monitor.

Environment

All SAM versions

Cause:

The cause of this issue is the component is set to use "SQL Server Authentication" first when SQL Server Authentication is possibly disabled on the server. 

Resolution:

1. Log into your Web console using a SAM administrator account.

2. Go to SAM Summary and under All Applications, click the Application Monitor assigned to the affected node.

3. Under the Application Details web resource, click Edit Application Monitor.

4. Locate the SQL User Experience monitor and then expand the component.

5. Select the Use Windows Authentication first option.

6. Click Submit.

 

Last modified

Tags

Classifications

Public