thx steve, that link is taking me to adult content.   i got out as fast as i could.

i always use the advanced tab for these kinds of things.   So i...

• This reply was modified 6 days, 2 hours ago by stan.

...and notice in the following 2 posts the lists of 64 bit and 32 bit drivers...i dont know why one runs C:\Windows\System32\odbcad32.exe for 64 and C:\Windows\SysWOW64\odbcad32.exe for 32.

• This reply was modified 6 days, 2 hours ago by stan.

i'm out of my comfort zone but notice in the following 2 posts , there is no certificate. and no encryption.   So how/why is ssas complaining about encryption?

thx frederico, for the moment one of our partners puts 6 files there daily...   and yes , while the 6 files are a drop in the bucket, all clients send...

thx steve, brian, frederico.   early indications are that this is what im going to have to use. ..

Globalscape EFT Arcus, a cloud-based Managed File Transfer (MFT) service that supports FTP, but also...

i "create or replaced" the conn script with the change you see below.   I did the same changing encrypt=true.   i tried with just trustserver...same error all 3  ways.

;TrustServerCertificate=True;Encrypt=False;

does anybody have...

i'll post the conn string info (from ssas to the engine) images separately as my reply just disappeared.   this conn string has never been a problem before.   i'll poke around...

this is all good to know.  What are the risks we've avoided in the last 2 yrs of not using encryption on these dw oriented servers?  ssrs , ssms, pbi,...

i think i get it.

1. on my pc where i have vs2022 with ssis extension installed, importing an ssis project from our 2019 sql server is always going to break...

• This reply was modified 1 months ago by stan.