SQL Integrated Windows Authentication supported in federation flow

Question

we recently moved from on-prem adfs servers to a PTA solution.

Since then when we try to connect to our Azure database using the below it fails. Any ideas on workarounds or fixes?

sqlcmd -S tcp:<>dbname.database.windows.net,1433 -d master -G

 

-> Get error as follows:

 

Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Failed to authenticate the user '' in Active Directory (Authentication option is 'ActiveDirectoryIntegrated').
Error code 0xCAA9001F; state 10
Integrated Windows authentication supported only in federation flow..

Our setup is as follows:

Answer 1

Hi,@NP Welcome to Microsoft Q&A thanks for posting your question.

Beyond the use of explicit username and password I don’t think there any specific suggestions. (https://learn.microsoft.com/en-us/sql/tools/sqlcmd/sqlcmd-authentication?view=sql-server-ver16&tabs=odbc#azure-active-directory-username-and-password),

However, I will check with internal product team and provide you with more details.

Regards

Geetha

Answer 2

@NP There is a document about a similar error, hopefully the solution it suggests would be helpful here as well.

https://learn.microsoft.com/en-us/troubleshoot/mem/intune/device-enrollment/mdm-enrollment-error-0xcaa9001f

Regards

Geetha