SQL Integrated Windows Authentication supported in federation flow
NP
461
Reputation points
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..
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,228 questions
Sign in to answer