For Active Directory Integrated set authentication=ActiveDirectoryIntegrated.

To use the various authentication types, amend your JDBC URL to set the authentication parameter:

Azure Active Directory with MFA (not supported)*.

There are several types of Azure Active Directory authentication:

Download the archive and add it to the lib folder in your command-line installation.Paste the following into the Maven XML box:.

To do this, you can use the JAR Download tool to find ADAL4J and its dependencies: Maven should then deal with getting ADAL4J's dependencies itself.įor command line users, you'll have to download them all manually. If you're using Flyway in an environment that is integrated with Maven or Gradle (Like the Maven or Gradle plugin), you only need to add ADAL4J's Maven package as a dependency in your pom.xml. To use Flyway with Azure Active Directory connections, you must install ADAL4J and it's dependencies. Windows Authentication, also known as Integrated Security, is enabled by amending your JDBC connection string to set integratedSecurity=true.Įxample: jdbc:sqlserver://host:port databaseName=database integratedSecurity=true. Provide these with the user and password configuration options. This uses a straightforward username and password to authenticate. You may have to perform your own research to get the JDBC driver working for the different authentication types. Flyway depends on Microsoft's JDBC drivers, which in turn have many environmental dependencies to enable different authentication types. Note These instructions may be incomplete. Refer to this when troubleshooting authentication problems. The instructions provided here are adapted from the Microsoft JDBC Driver for SQL Server documentation. SQL Server Authentication works 'out-of-the-box' with Flyway, whereas Windows Authentication and Azure Active Directory require extra manual setup. SQL Server supports several methods of authentication. Placeholder INSERT INTO $ (name) VALUES ( 'Mr.

* Multi-line comment */ - TSQL CREATE TRIGGER dbo.Update_Customer_Priority * Single line comment */ CREATE TABLE Customers (

Flyway sql server connection string