"Windows logins are not supported in the version of SQL Server" error

[poojamate92]

Hi Team,

I'm facing issue while connecting to Microsoft Azure SQL Database/Microsoft SQL Server. It is throwing below error-

Connection Failed

SQLState: 'HY000'

SQL Server Error: 40607

[Microsoft][SQL Server Native Client 11.0][SQL Server]Windows login are not supported in this version of SQL server.

I'm trying windows login method to connect and we don't have problem doing so through PowerBI or Power query. 

Can anyone know about this error? Can you please point me in the right direction to resolve this issue?

Thanks in advance!

[DanM]

@poojamate92  based on the error you are receiving it looks as if it wants you to use SQL credentials and not Windows. If you search the error the most common issue is "The Microsoft SQL Server Engine is not configured for mixed-mode authentication (SQL Server and Windows Authentication Mode)"