Submit a ticketCall us

whitepaperYour VM Perplexities Called, and They Need You to Read This.

Virtualization can give you enormous flexibility with future workloads and can be a key enabler for other areas, like cloud computing and disaster recovery. So, how can you get a handle on the performance challenges in your virtual environment and manage deployments without erasing the potential upside? Learn the four key areas you need to be focusing on to help deliver a healthy and well-performing data center.

Get your free white paper.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > DPA repository creation on Azure SQL fails when the user name contains an @ symbol

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

Updated January 29, 2019

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).".

Environment

  • DPA 11.0 and later

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

 

 
Last modified

Tags

Classifications

Public