Error when connecting excel to SQL Server

New Contributor
Hello all,

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

Barath
1 Reply

@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...