I am getting an error when trying to connect excel to sql server. I have attached the image of the error. I need to fix this error. Any help is appreciated
@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...
