ERROR Login failed for user - Microsoft SQL Server Integration when using Active Directory User in Aria Operations

Products

• VMware Aria Suite

Issue/Introduction

If you receive test connection or collection errors with the following message:

"The Login is from an untrusted domain and cannot be used with integrated authentication"

or

"Login failed for user "

 

 

Environment

Management Pack for Microsoft SQL Server

Aria Operations 

Resolution

To resolve this error message, set the option "Use NTLM V2" to True in the adapter instance configuration under Advanced Settings.

You are seeing this message because your environment is set to use NTLM authentication.

Please see the screenshot below for details: