Unable to Connect we encountered an error while trying to connect with Microsoft SQL
Hello Guys, while i am trying to connect to SQL Server, it was showing some error message. The content of the error message can be found below in bold.. Details: "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.)" For reference please check with the screenshot of the error message which was attached to this post or message.. Kindly put down the solution(s) in step by step manner as it would be helpful to me and the PBI community as well...
Report Server stored credentials - Couldn't connect
Hi all, I have a report that connects to a Microsoft SQL 2014 database using database credentials. It works fine when running in Power BI Desktop, but when I deploy the report to the server and try to store the data source credentials to schedule a refresh I get the following error: "Couldn't connect. The report server couldn't connect to the data source using the information you entered..." Further details are: "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 message received was unexpected or badly formatted)" We are running the August 2018 version of Report Server, and the data refresh works fine in the August 2018 RS version of Power BI Desktop. I have tried turning off the "Encrypt connections" option in the report but get the same result. Any ideas? Michelle
