Getting "SSL Provider, error" calling particular database procedure

[mark4BI-SGF]

I've seen some other postings about the error "SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.", but my situation might be different.

My situation is different, because the procedure references a link to another SQL database on the same server.

1. I can call an SQL Server procedure to import into a data table as long as the data objects are in the same database.

2. I can run this procedure in SSMS with the same user that I use to connect to SQL Server with through Power BI desktop.

3. I can run the query in the stored procedure that links to tables in the other database.

There is a post by Adam Saxton which has steps for creating an SSL certificate. Since the above works, I'm not convinced that I need to follow these steps. Adam does state "We would get a failure in a different application as well, such as Management Studio."

https://powerbi.microsoft.com/en-us/blog/ssl-security-error-with-data-source/

Is there a limitation in Power BI or is there some configuration somewhere that I might have missed or any other ideas?

Thanks in advance!

[v-yulgu-msft]

Hi @mark4BI-SGF,

As Power BI Desktop uses the windows certificate store to decide what to trust, please try to copy SSL certificate for the server where hosted SQL database to the machine running Power BI Desktop and import it to Windows certificate store.  

Regards,

Yuliana Gu

[mark4BI-SGF]

Thanks for the quick response. However, I'm not very well experienced with certificates, so I'm lost. I don't know that the database server has an SSL certificate. When I bring up certificates in MMC, I don't know which one to export.

When you say to "import it to Windows certificate store", do you mean using MMC on my desktop with Power BI or something else? When I type "Windows certificate store" in the search on my Windows 10 machine, I don't have any matches.