Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

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 in to 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