thx steve, that was already done in step #2 following your recommendation.   #1 just proved that db was accessible from another client.

i'm wondering if the community has heard that there...

• This reply was modified 3 weeks, 4 days ago by stan.

i tried MSOLEDBSQL (in ssas's conn string to the engine) instead of sqlncli11 but got the same error.  it might be time to bring in MS.

• This reply was modified 3 weeks, 4 days ago by stan.

thx steve, these are the steps i followed and i should mention that one of our network guys says all ports are open...

1.  from ssms on my local i connected...

• This reply was modified 3 weeks, 4 days ago by stan.
• This reply was modified 3 weeks, 4 days ago by stan.

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 3 weeks, 6 days 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 3 weeks, 6 days 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...