Hello,
I need to fetch data in my client SQL Database, one of their database required "Active Directory - Password" Authentication to Log In. When I try to set up a database connection in the Service Center it gave me error message "Connection String test failed: Cannot open server " *client domain name* " requested by the login. The login failed."
How to solve this?
Hi Kevin Wie,
You may want to check this post or this post for examples of Connection Strings that should work with Azure's Active Directory - Password authentication. You can use the details explained there to tweak the connection string used by your Database Connection (you will likely need to choose Advanced in the Database Connection configurations.
This document also has a section on connection to Azure SQL using AD.
I found this page on Microsoft's documentation about the connection properties it supports (might be useful even if it is for Java/JDBC).
Hope these help
Jorge Martins wrote:
Hello Jorge,
Now i got this error
Which I already tried to reinstall the adasql and check the registry but still get this error.
Kevin Wie wrote:
This needs to be installed on the platform server, not your personal computer.
So, I need to file a support ticket then.
Thanks Jorge
Did installing the dll in platform server solved the issue?
Did this get solved? Can you please share the format used for connection string syntax used for Azure AD using Azure AD Password auth.