Applications Systems

DPA repository creation on Azure SQL fails when the user name contains an @ symbol

To create the DPA repository on Azure SQL, do not enter the user name in a format that includes an @ symbol.

First published date

3/18/2019 6:52 PM

Last published date

3/18/2019 6:52 PM

Overview

When you attempt to create the DPA repository on an Azure SQL database, repository creation fails if you enter the user name in a format that contains an @ symbol (for example, dpa@myserver) on the Enter Repository Connection Information panel.

If the user name contains an @ symbol, the Repository Wizard returns an error message similar to the following:

An unknown error has occurred. The provided message is "Could not get JDBC Connection; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Failed to authenticate the user dpa@myserver in Active Directory (Authentication=ActiveDirectoryPassword).".

Product section

Database Performance Analyzer

Cause

Because of the @ symbol, DPA attempts to connect to the Azure SQL database using LDAP authentication.

Resolution

Enter the user name in a format without the @ symbol. For example, instead of dpa@myserver, enter only dpa.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.