Skip to content

SSRS Subscription Auth Error

23/12/2015

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 🙂

 

Advertisements

From → Uncategorized

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: