The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi!
I am connecting to my SQL Server Database. I successfully did it using Windows authentication option. Then I tested Microsoft option (my bad). Now every time I get this message: "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.)"
The problem, I can't get back to choose Windows authentication option. How can it be resolved?
Thank you!
Kind regards,
Alexandra
Solved! Go to Solution.
I resolved the issue.
Just needed to clear permissions under Global permissions in Data Source Settings.
Hope, its helpful.
I resolved the issue.
Just needed to clear permissions under Global permissions in Data Source Settings.
Hope, its helpful.
I worked like a glove! 🙂 Thanks a lot! 🙂