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
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-without-validation?view=sql-server-2017
