Custom SSRS reports not working after AOS Load Balancer configuration

(0) Share

Report

Posted on by Rahat Ali

275

Dear All,

I tried to search almost everywhere and couldn't find any suitable or related answer so I decided to put my query here.

I recently configured "Load Balancer" on just AOS level {(1)Dedicated Load Balancer AOS as and (2) Active AOS's batch server} (NOT NETWORK LOAD BALANCER) and added multiple AOS pointers of SSRS. The problem is all the system reports work just fine, it opens perfectly however the custom reports which we developed are showing "Access denied" error on multiple (system/user-defined) tables/views.

I've added those tables/views in "Security/Privileges" and "Roles" under "Tables" too but no luck. Can anyone please suggest me what I'm missing here?

All responses (2)

Answers (0)

Herbie @ Microsoft on at

Like (0)

Report

RE: Custom SSRS reports not working after AOS Load Balancer configuration

Rahat, if this is still an issue, have you reviewed the narrative at: cloudblogs.microsoft.com/.../

Otherwise, it is odd that this happens on only custom reports. Are there additional errors that you have uncovered in the event viewer?

I presume a review of any connection / credential use by the load balancer - is that running as a system account that does not have adequate permissions or represented in 2012? Just a thought, but I think we need a bit more information.
Crispin John Augustine 37,081 on at

Like (0)

Report

RE: Custom SSRS reports not working after AOS Load Balancer configuration

Just a guess, could be due to the AOS-Report server connection. Login to all the AOS servers and test report server connection with the local client.