cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Alexandrini Advocate I
Advocate I

Authentication options for SQL Server

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

1 ACCEPTED SOLUTION

Accepted Solutions
Alexandrini Advocate I
Advocate I

Re: Authentication options for SQL Server

I resolved the issue.

 

Just needed to clear permissions under Global permissions in Data Source Settings.

 

Hope, its helpful.

View solution in original post

2 REPLIES 2
Alexandrini Advocate I
Advocate I

Re: Authentication options for SQL Server

I resolved the issue.

 

Just needed to clear permissions under Global permissions in Data Source Settings.

 

Hope, its helpful.

View solution in original post

Highlighted
marthafrancisco
Regular Visitor

Re: Authentication options for SQL Server

I worked like a glove! 🙂 Thanks a lot! 🙂

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors