IBM Support

Unable to authenticate successfully when creating an Azure connection with Secure Gateway

Troubleshooting


Problem

A valid Azure connection, created by using Secure Gateway, fails to test successfully.

Symptom

Error:
Connection failed due to invalid credentials.

Environment

Planning Analytics on Cloud
Azure database that uses a hostname similar to xxxx.database.windows.net

Resolving The Problem

The username must be suffixed with the data source hostname. 
For example, if my hostname is myazure.database.windows.net and my user is test, the username in Planning Analytics will be test@myazure

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"ARM Category":[{"code":"a8m0z000000boHzAAI","label":"Planning Analytics-\u003EPlanning Analytics On Cloud Specific-\u003ESecure Gateway Cloud Only"}],"ARM Case Number":"TS010990983","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
21 November 2022

UID

ibm16840711