Click here to Skip to main content
15,867,764 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Error Message attempting to download data from my SQL Server 2017 dev edition.

0 - The certificate chain was issued by an authority that is not trusted.

I've tried so many suggestions and it's probably because I'm not a certificate expert.

So. Two questions.

As a person with limited DBA experience with advanced settings, how do I resolve this

OR

If I reinstall the same version of SQL Server, will certificates automatically be created?

What I have tried:

My suggestions by Users in CodeProject, all unsuccessfull (probably because of my limited understanding of certificates, which ones to recreate, etc.)
Posted
Updated 9-Mar-21 4:17am
Comments
NotTodayYo 9-Mar-21 11:11am    
Where are you trying to download it from?
stfromli 9-Mar-21 11:41am    
I'm connected to the database with a powerbi dashboard. I think this was working until i accidentally closed down my laptop with powerbi active and connected to my SQL Server database.

I then tried to connect to the database using excel, word, etc. but no matter what external software i use i get exactly the same message.
NotTodayYo 9-Mar-21 11:49am    
Where is your db? Azure? On your own server? I still don't quite follow exactly what you are doing.
stfromli 9-Mar-21 13:52pm    
My database is SQL Server 2017 dev edition and my office/powerbi software is on the same laptop as my SQL Server.

When you connect to your SQL server using excel or powerbi or any office 365 product, you can connect to the database seamlessly as long as you have the id and password. Up until recently i could. Now the error that I reported is preventing me from using my excel, word, powerbi, etc. to connect to the database. The error occurs that I reported in my original question

The actual error is
Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)
RedDk 9-Mar-21 13:20pm    
Try (under Additional Connection Parameters tab of "Connect to Server" dialog) typing:

TrustServerCertificate=True

The word in forums other than CP is that doing this is not a good idea. So see if it works then perhaps rollback your success to see if you can get login to fail again (back to current state). And think about it.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900