JDBC and Multi-Factor Authentication (MFA)

[Luis Pecht]

Hi , this question goes to Kevin Crow (StataCorp) , but may interest others.


when using

local url "jdbc:sqlserver://serverName....; Authentication=ActiveDirectoryIntegrated"
local driverclass "com.microsoft.sqlserver.jdbc.SQLServerDriver"
local user "a@b"
local pass "x"
jdbc connect, jarpath("`jarpath'") driverclass("`driverclass'") url("`url'") user("`user'") password("`pass'")
jdbc showdbs

the driver returns

connection failed
It is not possible to use "Authentication=ActiveDirectoryIntegrated" with the keyword "User", "UserName" or "Password" in the connection string]

however, helps file says:

Either jar("JarFileName") or jarpath("DirectoryName") and driverclass("ClassName"), url("URL"), user("UserID"), and password("Password") are
required with jdbc add. These options are also required with jdbc connect when DataSourceName is not specifie

Any thoughts in here?

thanks