Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

AWS Glue JDBC connection to Azure managed SQL Server using Azure Active Directory - Password authentication

0

I am exploring AWS Glue connections. I have successfully connected Glue to our EC2 hosted Microsoft SQL Server (in a VPC).

We also use a 3rd party Azure-hosted SQL Server that uses "Azure Active Directory - Password" authentication mechanism. Unfortunately, it does not seem like specifying the "authentication" attribute to the JDBC connection URL is supported in AWS Glue.

jdbc:sqlserver://mydbserver.database.windows.net:1433;DATABASE=MyDBName;authentication=ActiveDirectoryPassword

When I test the connection, I get this error: "JDBC connection URL jdbc:sqlserver://mydbserver.database.windows.net:1433;DATABASE=MyDBName;authentication=ActiveDirectoryPassword is not supported. Check the Developer Guide for the list of supported data stores / URL formatting."

I have also tried to download the latest MS JDBC driver (to ensure the driver version SHOULD support the authentication attribute) for SQL Server and specify it as the JDBC driver to use, but I get the same exact error.

Can anyone confirm that we cannot use Azure Active Directory - Password to connect to SQL Server on Azure? Or how use the authentication mechanism?

Thank you

Topics
AnalyticsDatabaseAWS Well-Architected Framework
Tags
Microsoft SQL ServerAWS GlueDatabaseSecurity
Language
English
asked 2 years ago1.6K views
1 Answer
1
Accepted Answer

Yes, AD authentication is not currently supported in AWS Glue, the reason is that to integrate with the domain, there are a series of library and configuration requirements that Glue at this time doesn't have.

AWS
EXPERT
answered 2 years ago
EXPERT
reviewed 2 years ago
EXPERT
reviewed 2 years ago
  • Jean-Francois
    2 years ago

    Thank you so much for the clear answer. Can't say that I am not disappointed as this means Glue might not work for our needs, but again thank you for the clear answer.

  • CMPTRGK
    2 years ago

    Does this only pertain to Azure AD authentication or to Active directory authentication as well.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content