Hide this message
Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.
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.
SAM version 6.2
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.