Troubleshooting
Problem
An Azure Synapse datasource connection fails when testing the datasource connection with correct username and password credentials within the Secure Gateway datasource connection of Planning Analytics Administration on Cloud environment.
When using the same credentials within SQL Server Management Studio, the credentials work successfully.
When using the same credentials within SQL Server Management Studio, the credentials work successfully.
Symptom
Error
Connection failed due to invalid credentials
Connection failed due to invalid credentials
Environment
Planning Analytics On Cloud Environment
Azure Synapse datasource
Azure Synapse datasource
Diagnosing The Problem
For Azure Synapse datasource connections, the username must include the synapse database server host name
Resolving The Problem
STEPS:
1. In Planning Analytics Secure Gateway datasource test connection, enter the username as follows:
username@testserversynapse (Change the username to the username that works successfully)
Example:
Synapse Host Database server = testserversynapse.sql.azuresynapse.net:1433
Username = ibm
The Login box entry would be specified as: ibm@testserversynapse
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":"TS011795348","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
18 January 2023
UID
ibm16856231