Error
Error

Reputation: 825

Error while running ssrs subscription using windows file share

In log files i have this 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.

SSRS has account type network service and it's running. I've created folder for writing pdf report, made folder as shared and gave Everyone group full control.

When I go to website where report is, everything is working, but when I add subscription for that report, I always got same error in log. I have running Sql profiler to catch callih procedure for report, but it's never called from subscription. In ssrs configuration, I haven't specified delivery email because I don't need it.

Upvotes: 2

Views: 4323

Answers (2)

BeiBei ZHU
BeiBei ZHU

Reputation: 363

what am I do is set Subscription and Execution same with Service account, but I'm not use Subscription actually, but this fixed issue.

Upvotes: 0

Christopher M. Brown
Christopher M. Brown

Reputation: 2210

You need to ensure that your service account has the Windows Authorization Access permission.

You can find more information on this here.

Also, whenever a new subscription is created, it is usually created under the account of the individual who is logged into the SSRS session that created it. This can be changed, and there are directions on how to do this here.

So, in summary, you need to make sure that the account the subscription is running under is in the Windows Authorization Access (WAA) group.

Upvotes: 0

Related Questions