Can't connect to Azure SQL DB.

Answered

Permanently deleted user

Created May 22, 2019 08:31

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

3 comments

Maxim Sobolevskiy

Created May 27, 2019 04:44

Hi! It seems that database gives you this error, not DataGrip: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-develop-error-messages

Permanently deleted user

Created May 30, 2019 11:26

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.

Permanently deleted user

Created April 30, 2020 23:22

Hi,

Is there any resolution on this? I'm having the same issue.

Thanks.

Please sign in to leave a comment.