Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I just installed the power bi report server then configured the report server, but when I tried to load the report site I have this error: Could not load file or assembly 'System.Transactions.dll' or one of its dependencies. Access is denied
When you see the error are you getting it in a dialog popup in Report Manager/Portal or did you get it from one of the Report Server log files, if it's from the logs which one did you get it from? Also when you configured your server which account did you use to configure the Report Server service?
I see the error in the Report Server Web Service URL.
The Report Server Service is configured with Network Service,
Can you tell me a little more about the configuration of your server:
1. What OS are you installing on?
2. Do you have the .NET Framework installed, if so which versions?
3. Which endpoint are you hitting when you get the error http://servername/reports or http://servername/reportserver
4. Do you see any errors in the Event Viewer/Log?
5. Do you get the error when you first hit the page or when you try to render a report? If it's the latter what type of report are you trying to open (RDL, PBIX, Mobile Report)?
The error looks like the service account is hitting a permissions issue accessing .NET but I would imagine there would be bigger issues if this was the case.
Your answers
1. Windows Server 2012 R2 Standard.
2. Yes I have .Net Framework installed, v 3.5, 4.5, 4.5.1, 4.5.2
3. With http://servername/reports I see error 503. The service is unavailable and with http://servername/reportserver I see "Could not load file or assembly 'System.Transactions.dll' or one of its dependencies. Access is denied."
4. Yes I see an error on Event Viewer but with no detail and also on ReportingServicesServiceTimestamp log with same error: "System.IO.FileLoadException: Could not load file or assembly 'System.Transactions.dll' or one of its dependencies. Access is denied"
5. When I first hit the page.
I configured the service account with Network Service and later with a domain account with both accounts I have the same error.
Ok this definitely looks like a machine config issue, there's couple things we can look at/try:
Let me know what you find. Thanks!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
3 | |
2 | |
1 | |
1 | |
1 |