Custom SSRS reports not working after AOS Load Balancer configuration

(0) Share

Report

Posted on by Rahat Ali

281

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?

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Crispin John Augustine 37,081 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Herbie @ Microsoft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No