Connect Azure Search Service to SQL Server on Azure VM -

i'm in azure portal ui attempting connect our new azure search service our sql server on our azure vm. ui asks me connection string, username , password. started using exact connection string used in our .net config files, there no issue connecting. no matter how tweak connection string based on many threads i've read here @ s/o (set encrypt false, set trustservercertificate true) error testing connection:

"a connection established server, error occurred during login process. (provider: ssl provider, error: 0 - certificate chain issued authority not trusted.) learn more connecting azure sql vms, http://go.microsoft.com/fwlink/?linkid=826562"

i must admit info in ms link foreign language me. none of steps have ever been required me connect sql server, continued research lead me different aforementioned tweaks connection string.

as none of these tweaks worked, seems answer lies in ms article - able provide step-by-step new certificates.

i'd still fail understand why have no issues connecting sql server other app/service/util , error here, if works works , won't complain!

the basic issue here sql server must have certificate issued trusted certificate authority, not self-signed cert typically used in intranet apps. suspect connection strings worked in other apps because either don't use encryption or trust self-signed certs (that's trustservercertificate setting does).

please follow directions in article linked - that's authoritative step-by-step guide i'm aware of.

alternatively, if don't want configure certificate , ports, can consider using azure data factory push data azure search.