Search found 1 match

by sqlpat
Fri 05 Jun 2020 10:25
Forum: SQL Server Data Access Components
Topic: Azure connect with AAD not work
Replies: 7
Views: 27705

Azure connect with AAD not work

Hello

I wanna connect to a Azure SQL Database with Azure Active Directory Login. I will use a connectionstring like this:

Server=tcp:mysql.database.windows.net,1433;Initial Catalog=myDB;Persist Security Info=False;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Authentication="Active Directory Integrated"

Then i will bevome this error: "Login failed for user sa".

Is the SDAC Component not compatible with Azure Active Directory Authentication ?

many thanks for help.

Kindly Regards
Pat