SQL Integrated Windows Authentication supported in federation flow

NP 461 Reputation points
2023-12-13T00:11:14.5466667+00:00

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

Since then, when running the below sql command we get the error listed. Anything we can do to get around it?

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..

User's image

Azure SQL Database
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.