Forum Discussion
Trust server certificate
Hi hcv,
Thank you for reaching out to Microsoft Fabric Community.
Thank you rohit1991 for the prompt response.
If there are 100+ SQL server instances, manually trusting certificates for each one would be inefficient. If the SQL server instances use certificates from an internal Certificate Authority (CA), import the Root CA certificate into the Trusted Root Certification Authorities store on the machine running the power bi gateway. This ensures all certificates issued by that CA are automatically trusted and no need to import each SQL Server certificate manually.
Regarding the additional task, there is no need to trust each instance separately if the Root CA certificate is imported once.
Yes the SSL certificates expires, but if we use a Root CA, only the CA certificate needs to be renewed and re-imported when it expires.
Microsoft does not have specific documentation for this exact scenario, but below resources may be helpful:
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Anjan Kumar Chippa
Thanx for your reply!
What is the best option when the company you work for has 100, or more, SQL Server instances? On Power BI Desktop you can refer to *.mydomain.local for all the instances.
Is this an additional task for every installed instance?
Do the SSL certificates expire after some time? And do you have to update the import root certificates?
Is there some documentation on the options you describe?
Hi hcv,
Thank you for reaching out to Microsoft Fabric Community.
Thank you rohit1991 for the prompt response.
If there are 100+ SQL server instances, manually trusting certificates for each one would be inefficient. If the SQL server instances use certificates from an internal Certificate Authority (CA), import the Root CA certificate into the Trusted Root Certification Authorities store on the machine running the power bi gateway. This ensures all certificates issued by that CA are automatically trusted and no need to import each SQL Server certificate manually.
Regarding the additional task, there is no need to trust each instance separately if the Root CA certificate is imported once.
Yes the SSL certificates expires, but if we use a Root CA, only the CA certificate needs to be renewed and re-imported when it expires.
Microsoft does not have specific documentation for this exact scenario, but below resources may be helpful:
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Anjan Kumar Chippa
Hi hcv,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.
If my response addressed, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Thanks and regards,
Anjan Kumar Chippa