Jul 16 2019 03:53 AM - edited Jul 16 2019 03:53 AM
Jul 18 2019 01:45 PM
@nynamynaMost of my experience between Excel and SQL is via Power Query, so sorry if this doesn't apply.
SQL by default uses a self generated certificate that would not be trusted by other machines. You have some options - loosely in order of easiest to more secure
Don't use an encrypted connection - I observed Power Query offer this option during a get data wizard recently - from the resulting .odc file "Use Encryption for Data=False"
Connect using an option to accept untrusted certificates - the strings vary - you might have a look here
https://docs.microsoft.com/en-us/sql/relational-databases/native-client/features/using-encryption-wi...