I recently moved some SSRS subscriptions between domains, there is a oneway trust between them, however when publishing a report to the desination domain using a user in the source domain the subscription errors with the following.

library!WindowsService_0!182c!12/23/2015-10:34:13:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service account doesn’t have rights to check domain user SIDs., Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;

This is happens because SSRS needs to verify the subscription owner’s access to the report prior to generating and sending it. This error occurrs when you choose Windows  File Share or Send e-Mail option. As the source domain didn’t trust the destination domain that it why this failed.

However a fix bit of SQL to fix up the Subscription owner was all that was needed.

The SQL below will set the owner to be “NT Authority\System” to all subscriptions

Use ReportServer Go Declare @System as varchar (200) Select @System=(Select UserId from Users where UserName= 'NT AUTHORITY\SYSTEM') --Select * from dbo.Subscriptions where OwnerID <> @System Update dbo.Subscriptions set OwnerID=@System where OwnerID <> @System

I hope this can help others :)