Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

Home > Success Center > Server & Application Monitor (SAM) > Use a domain user to monitor AppInsight for SQL through an agent

Use a domain user to monitor AppInsight for SQL through an agent

Table of contents

Overview

This article describes how to modify the SAM agent to use interactive authentication when monitoring AppInsight for SQL so that standard domain users (not admin users) can be used to monitor AppInsight for SQL. Before attempting these changes, verify the AppInsight for SQL Requirements and Permissions are set for the target server, especially requirement for “Log on as a batch job” policy for the account.

Environment

SAM version 6.2

Steps

 

First, before attempting any resolutions, verify the requirements and permissions for AppInsight for SQL. See this article AppInsight for SQL Requirements and Permissions, paying specific attention to the requirement for “Log on as a batch job” policy for the account.


Important: Verify the target domain account has the required SQL permissions. 

 

If the requirements and permissions do not connect the domain account properly, set the account permissions to Allow Logon Locally. For more information, see this Microsoft Technet article: https://technet.microsoft.com/en-us/library/cc957151.aspx?f=255&MSPPError=-2147217396

These instructions require modifying SAM agent package files.

  1. On the target system, set the domain user account permissions to Allow Logon Locally to allow the credentials to log on locally to the server being monitored.
  2. Open the Group Policy, select Computer Configuration > Policies > Windows Settings > Security Settings > Local Policies > User Rights Assignment and select the  Allow Logon Locally option.
  3. ​Back up the file APM_6.2.1.2395.apkg located in Orion\AgentManagement\Plugins in the SolarWinds install folder.
  4. Extract the contents of the APM_6.2.1.2395.apkg file (this file can be considered a zip archive for these actions).
  5. Open the file SolarWinds.APM.Probes.dll.config for editing.
  6. Change the setting 
    <SqlServerProbeSettings LocalLogonType="Batch" /> 
    to 
    <SqlServerProbeSettings LocalLogonType="Interactive" />
    This setting changes from batch mode to interactive mode.
  7. Rebuild the file APM_6.2.1.2395.apkg with this modified version of APM_6.2.1.2395.apkg. The file will be redistributed to all agents. 

 

 

Last modified
09:31, 8 Mar 2017

Tags

Classifications

Public