All
Accepted answers
Joel Espinoza · Dec 7, 2020 go to post

In addition to Scott answer, I need to add one additional parameter:

databaseName=<database>;trustServerCertificate=true;domain=<domain>;useNTLMv2=true;cacheMetaData=true;prepareSQL=2

Thanks for the post Scott, it was very helpful!

Regards, Joel

Joel Espinoza · Oct 11, 2022 go to post

To encrypt to MD5 (as javascript, unix and others) I writed this classmethod, using information found here, and works very well.

ClassMethodEncripta(pass)As%String
{
setintermedio=##class(%SYSTEM.Encryption).MD5Hash(pass)
setmd5HashHex=""
fori=1:1:$Length(intermedio){
sethexaIntermedio=$Zhex($Ascii($Extract(intermedio,i)))
if$Length(hexaIntermedio)=1{
sethexaIntermedio="0"_hexaIntermedio
}
setmd5HashHex=md5HashHex_hexaIntermedio
}
return$ZConvert(md5HashHex,"L")
}

Just need to use " d Encripta("word")"

I hope could be useful!

Joe!