Can't connect to Azure SQL DB.

Answered

I use DataGrip 2019.1.2

I've followed the steps as described here https://www.jetbrains.com/help/datagrip/connecting-to-a-database.html#ms_azure

I use Azure Active Directory Authentication so I've selected 'Use Windows domain authentication'

But I get this error:

The specified database user/password combination is rejected: [S0001][40607] Windows logins are not supported in this version of SQL Server. ClientConnectionId:0c784e06-2e36-4b1f-8442-ea568c9b8b42

 

Thanks,

Ruslan

2 comments

Hi, yes it is coming from SQL because Azure Active Directory is not working as described in the documentation: https://www.jetbrains.com/help/datagrip/connecting-to-a-database.html#ms_azure . It look like Azure Active Directory is not support in default installation.

The step below from the documentation:

To use Azure Active Directory Authentication, select Use Windows domain authentication.

Is not working. I think it tries to connect to Azure using Windows Domain Authentication not Azure Active Directory, hence the message.

Thanks.

0

Please sign in to leave a comment.