Question:
How can I build connection string for connecting to Azure SQL Database using Azure AD account?
Currently, I am using the following but it does not seem to be correct. It does not use Authentication Type: Active Directory Password.
Part of PowerShell script I am using:
|
1 2 |
server=$Server.database.windows.net;initial catalog=$Databasename;Authentication=Active Directory Password;Integrated Security=False;uid=$Username;password=$Password |
I really appreciate your help.
Answer:
I managed to resolve the issue; It was actually the order of properties.
The following connection string worked
|
1 2 |
Data Source=$Server.database.windows.net;initial catalog=Master;User ID=$Username;password=$Password;authentication=Active Directory Password |
However, this does not work
|
1 2 |
Data Source=$Server.database.windows.net;initial catalog=Master;authentication=Active Directory Password;User ID=$Username;password=$Password |
The only difference is the order of “Authentication” tag.
I never thought order of properties matter in ConnectionString.