SCCM : Creating Report in Report Builder - SQL Server Error

I am trying to make a report using Report Builder, the SSCM uses the SQL Server database. I've followed the steps in this link and I created a DataSource and the connection is successful with the database : https://www.systemcenterdudes.com/sccm-report-creation-report-builder/

When I am creating the dataset, I am prompted to put the user credentials, I am getting this error:

Could not load file or assembly 'System.Transactions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. Either a required impersonation level was not provided, or the provided impersonation level is invalid. (Exception from HRESULT: 0x80070542)

I tried every possible solution on the internet to fix it but with no results, I even entered control panel -> system and security -> local security policy and I checked if the user was in the policy impersonate a client after authentication and it was already there.