Azure Managed Identity to connect to Azure Managed SQL instance
We are trying to utilise Azure Managed Identity for our Pega instance which is on Azure cloud to connect to Azure Managed database in Azure cloud.We are hard coding the password in the Connection string. We dont want to Hard code the connection properties in the JDBC connection string.Does PEGA 8.7.1 support Azure Managed Identity or any other suggestion to connect without hard coding the password.
CGI
US
@Mark Anan I have the same question.
Also, if this can be done for BIX.
Pegasystems Inc.
GB
@Mark Anan please could you take a look at the forum questions Is MsSQL supported in pega 8.7 on Azure and Pega on Azure cloud implementation?
The main documentation can be found under Configuring a Microsoft Azure authentication profile and Creating and updating external database instances with JDBC URLs
Molina Health Care
US
Hi Mark
We are still trying to connect using the managed identity and we received token error using the following connection string suggested by the team
#url: "jdbc:sqlserver://sc-sqlmi-cca-dev-02.da1a066f71e4.database.windows.net:1433;databaseName=DEV1_UM_Pega_Infinity_05;encrypt=true;trustServerCertificate=false;loginTimeout=30;selectMethod=cursor;sendStringParametersAsUnicode=false;Authentication=ActiveDirectoryMSI;msiClientId=877bffb4-ccde-4568-997c-dd177e81ef33;"
Error shown bellow
As per the microsoft documentation it is suggesting a different connection string format to be used for managed sql
url: "jdbc:sqlserver://sc-sqlmi-cca-dev-02.da1a066f71e4.database.windows.net:1433;databaseName=DEV1_UM_Pega_Infinity_05;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.da1a066f71e4.database.windows.net;loginTimeout=30;Authentication=ActiveDirectoryIntegrated;"
and we get the following error
Hi Mark
We are still trying to connect using the managed identity and we received token error using the following connection string suggested by the team
#url: "jdbc:sqlserver://sc-sqlmi-cca-dev-02.da1a066f71e4.database.windows.net:1433;databaseName=DEV1_UM_Pega_Infinity_05;encrypt=true;trustServerCertificate=false;loginTimeout=30;selectMethod=cursor;sendStringParametersAsUnicode=false;Authentication=ActiveDirectoryMSI;msiClientId=877bffb4-ccde-4568-997c-dd177e81ef33;"
Error shown bellow
As per the microsoft documentation it is suggesting a different connection string format to be used for managed sql
url: "jdbc:sqlserver://sc-sqlmi-cca-dev-02.da1a066f71e4.database.windows.net:1433;databaseName=DEV1_UM_Pega_Infinity_05;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.da1a066f71e4.database.windows.net;loginTimeout=30;Authentication=ActiveDirectoryIntegrated;"
and we get the following error
Will only use properties from file. java.sql.SQLException: Cannot create PoolableConnectionFactory (Failed to load both mssql-jdbc_auth-11.2.3.x64 and MSAL4J Java library for performing ActiveDirectoryIntegrated authentication. Please install one of them to proceed.)