Setting Up Connection to SQL Database Using Active Directory-Password Authentication

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:

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

Hello Jorge,

Now i got this error

Connection String test failed: Unable to load adalsql.dll (Authentication=ActiveDirectoryPassword). Error code: 0x2. For more information, see http://go.microsoft.com/fwlink/?LinkID=513072


Which I already tried to reinstall the adasql and check the registry but still get this error.

Kevin Wie wrote:

Hello Jorge,

Now i got this error

Connection String test failed: Unable to load adalsql.dll (Authentication=ActiveDirectoryPassword). Error code: 0x2. For more information, see http://go.microsoft.com/fwlink/?LinkID=513072


Which I already tried to reinstall the adasql and check the registry but still get this error.

This needs to be installed on the platform server, not your personal computer.


Jorge Martins wrote:

Kevin Wie wrote:

Hello Jorge,

Now i got this error

Connection String test failed: Unable to load adalsql.dll (Authentication=ActiveDirectoryPassword). Error code: 0x2. For more information, see http://go.microsoft.com/fwlink/?LinkID=513072


Which I already tried to reinstall the adasql and check the registry but still get this error.

This needs to be installed on the platform server, not your personal computer.


So, I need to file a support ticket then.

Thanks Jorge