How can we help you today? How can we help you today?

AAD Universal with MFA - error

I followed the guide for setup for using AAD Universal with MFA to connect to a database, but once successfully authenticated in the browser, I'm met with the following error:

Unable to obtain connection from database (jdbc:sqlserver://xxx.yyy.database.windows.net;authentication=activeDirectoryInteractive;databaseName=zzz;encrypt=true;integratedSecurity=false) for user '': Cannot set the AccessToken property if "Authentication" has been specified in the connection string. ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- SQL State : null Error Code : 0 Message : Cannot set the AccessToken property if "Authentication" has been specified in the connection string.


Is there something I missed in the setup or something not connected correctly?
Azhkanizkael
0

Comments

5 comments

  • ATurner
    Hi Azhkanizkael
    What version of flyway is it you are using? 
    ATurner
    0
  • Azhkanizkael
    I am on Flyway Enterprise, using the desktop client v6.0.0.
    Flyway Engine: 9.10.2
    Git: 2.22.0
    Redgate Compare: 1.6.0.7305
    Azhkanizkael
    0
  • Azhkanizkael
    This was solved by updating.

    The application itself didn't know there was an update, so I had to manually update.
    Azhkanizkael
    0
  • ATurner
    Hi Azhkanizkael

    Indeed this issue was resolved in 6.0.1 so later version should have this fixed.
    ATurner
    0
  • Aliya77
    I followed the guide for setup for using AAD Universal with MFA to connect to a database, but once successfully authenticated in the browser, I'm met with the following error:


    Hi
    It seems that there might be an issue with the authentication flow between AAD Universal with MFA and the database.




    Aliya77
    0

Add comment

Please sign in to leave a comment.