Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Server & Application Monitor (SAM) > SQL Monitor generates authentication errors in the SQL Server event log

SQL Monitor generates authentication errors in the SQL Server event log

Created by Riggs Clough, last modified by Rodim Suarez on Apr 05, 2017

Views: 191 Votes: 1 Revisions: 4

Overview

The SQL Monitor generates authentication errors in the SQL Server event log. This issue may occur if you are using SQL User Experience monitors or any monitor requesting access to the SQL server.

You may experience this problem if you are using SQL User Experience monitors (or any monitor asking for access to the Orion database server running Microsoft SQL Server. 

Environment

  • All SAM versions running an SQL User Experience Monitor
  • Mixed authentication environment (instead of SQL only) 

Cause 

The SQL User Experience Monitor is not configured to use Windows Authentication. Instead, the monitor uses the assigned credentials as an SQL credential. 

Resolution

  1. Go to the targeted application monitor.
  2. Click Edit Application Monitor.
  3. Expand the targeted SQL User Experience Monitor component.
  4. Make sure that the Ensure that the Used Windows Authentication First, then SQL Authentication option is selected.
  5. Save your changes. 

 

Last modified

Tags

Classifications

Public