Forum Discussion
Do57792
Advocate I
Advocate Icertificate chain was issued by an authority / PBI_SQL_TRUSTED_SERVERS
Hi, In a SQL query that I have run several times before I am not receiving the following error: Message=A connection was successfully established with the server, but then an error occurred ...
Case Closed. Using another connector helped to set up SQLs/connect to the database.
Using OLE DB was working well insted of SQL Server, which was working fine before the update.
My solution was to remove Microsoft.Data.SQLClient (Microsoft SQL Client Provider) from the msmdsrv.exe.config settings file and stop-start in Power BI Report Server.
Example of the command removed in msmdsrv.exe.config: