Forum Discussion
Error when connecting excel to SQL Server
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
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-without-validation?view=sql-server-2017