Submit a ticketCall us

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.

 

Home > Success Center > Server & Application Monitor (SAM) > Unable to log in to the AppInsight for SQL template

Unable to log in to the AppInsight for SQL template

Created by Jamin Walters, last modified by Rodim Suarez on Jul 06, 2016

Views: 26 Votes: 0 Revisions: 14

Overview

When you deploy AppInsight for SQL to a server using WMI as the node polling method, the monitor displays as Unknown and errors appear in the SQL server logs.

For example:  

LOGIN FAILED FOR USER XX\XXXXXXX.

REASON: ATTEMPTING TO USE AN NT ACCOUNT NAME WITH SQL SERVER AUTHENTICATION.

[CLIENT: XX.X.X.XXX]

Environment

All SAM versions

Cause 

The template is set to inherit credentials from the node, but the user connecting to the node does not have login credentials to the SQL database server. 

Resolution

You cannot edit login credentials in the Appinsight for SQL template. You can only edit user credentials on the Edit page once you install the application. Click Edit Application and edit the credential. 

See Appinsight for SQL requirements and permissions for related information. 

See the SolarWinds AppInsight Application Guide for more information about setting up AppInsight for SQL.

 

 

 

Last modified
17:45, 6 Jul 2016

Tags

Classifications

Public