July 4, 2005 at 2:42 pm
Hello Guys,
We started using RS in production environment from last few weeks after initial email tests ran fine but unfortunately email subscription has started failing quiet frequently for last few days. Interestingly it still works once in a while.
ReportServer service is running under LocalSystem account, it doesn't execute the subscription at all when I try running it under a domain account. Even tried domain administrator account in vain.
Following MS article comes up when searching with error message "AuthzInitializeContextFromSid: Win32 error: 1722;" from the log, but this article deals with the domain account setting, which in my case is not really applicable.
http://support.microsoft.com/Default.aspx?kbid=842423
Following are the messages from report log:
==============================================================================
ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files, AuthzInitializeContextFromSid: Win32 error: 1722;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files
ReportingServicesService!library!1b60!07/04/2005-14:18:05:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
ReportingServicesService!emailextension!1b60!07/04/2005-14:18:05:: Error sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report Server has encountered a configuration error; more details in the log files ---> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files
at Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String userName)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String userName, IntPtr userToken)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType catItemType, Byte[] secDesc, ReportOperation rptOper)
at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyDate)
at Microsoft.ReportingServices.Library.RSService._GetReportParameters(String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)
at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
--- End of inner exception stack trace ---
==============================================================================
Please let me know if you need more information.
Your help is greatly appreciated.
Thanks
AJ
July 7, 2005 at 8:00 am
This was removed by the editor as SPAM
July 12, 2005 at 8:35 am
We're having similar problems - the subscription errors out with Failure sending mail:..... The Win32 error code that I'm seeing in our log files is 1355, which according to the command net helpmsg 1355 is
The specified domain either does not exist or could not be contacted.
We applied a patch to the report server (not sure which one, as I'm not the administrator) and changed the account that the RS service is running under and the problem went away. Now it's back. It appears to be a permissions issue (??), but we can't figure it out.
This probably isn't much help, but if anyone else has more detail, please post it! Thanks!
August 7, 2009 at 8:25 am
I'm experiencing a similar issue, and am working on the resolution now.
Basically, SSRS E-mail subscriptions weren't delivering when they were configured to attach the report to the e-mail (i.e. PDF, CSV, etc.).
It was only working when a link was embedded in the e-mail.
I searched through the Trace Logs and found the following error:
"ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. , AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service account doesn't have rights to check domain user SIDs.;"
My SSRS service was using a Network Service Account, and some probing lead me to this Microsoft KB article:
http://support.microsoft.com/kb/842423/en-us
As I said, I'm going through the steps for Method 1 now, and will update the post when/if I've got a resolution.
Hope this offers some help/insight.
-SD
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply