March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |