CODEWITHSUNDEEP
azurepowershellazure-active-directoryazure-sql-database
Maysam Jahromi
Maysam Jahromi

Reputation: 113

Connection string for connecting to Azure SQL Database via Azure AD

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: 

server=$Server.database.windows.net;initial catalog=$Databasename;Authentication=Active Directory Password;Integrated Security=False;uid=$Username;password=$Password

I really appreciate your help.

Upvotes: 5

Views: 8422

Answers (2)

Maysam Jahromi
Maysam Jahromi

Reputation: 113

I managed to resolve the issue; It was actually the order of properties.

The following connection string worked

Data Source=$Server.database.windows.net;initial catalog=Master;User ID=$Username;password=$Password;authentication=Active Directory Password

However, this does not work

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.

Upvotes: 4

Martin Brandl
Martin Brandl

Reputation: 59021

In the example, they use this format:

Data Source=n9lxnyuzhv.database.windows.net; 
Authentication=Active Directory Password; 
Initial Catalog=testdb;  
[email protected]; 
PWD=MyPassWord!";

So try to use PWD instead of Password.

Upvotes: 0

Related Questions