SSRS Subscription TGGAU Rights: AuthzInitializeContextFromSid Exceptions

When you configure SSRS using a domain account and allow users to setup subscriptions sometimes SSRS failed on running these SQL Agent jobs by saying “Failure writing file Test SSRS : The report server has encountered a configuration error. See the report server log files for more information.” in the subscription console itself. However when…

1

How to: Invoke a C# Assembly in SSRS

While SSRS has a lot of capabilities there are certain limitations that require the brute force of the CLR. This a walkthrough on how to create, reference and call a method in a C# assembly through SSRS in IDE mode or in Report Server mode.  1.       First you need to create the C# assembly and make sure…