Report Server refuse to send attachments

Hi,
We recently encountered a problem with RS subscriptions: it suddenly stopped
sending attachmetns. Reports without attachments are sent without problems.
The RSReportServer.Config is defined properly (including the <SMTPServer>
and <From> properties.
This is part of the error file:
ReportingServicesService!library!3b2c!03/28/2005-12:01:20:: i INFO: Call to
RenderFirst( '/TNDReports/TicketCurrent' )
ReportingServicesService!library!3b2c!03/28/2005-12:01:20:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 1355;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
I noticed there is something with a HotFix (number KB834859) but I could not
get to it.
Server: Windows 2003 (Web server is seperated from database server)
RS Service Pack 1 installed.
SQL Server 2000 SP3a
Thanks in advance,
AvishayHi Avishay,
I believe the KB-article 834859 applies to the issue you are encountering.
As mentioined in the KB 834859, there is a known issue that
AuthzInitializeContextFromSid function passes a non-null-terminated string
to the DsGetDcName function. Apparently this issue potentially cause
problems when Windows report service tries to use this function. I've ever
seen some customers have resolved the similar issues by installing the
hotfix.
To obtain the hotfix, please contact Microsoft Product Support Services.
For a complete list of Microsoft Product Support Services phone numbers and
information about support costs, visit the following Microsoft Web site:
http://support.microsoft.com/default.aspx?scid=fh;[LN];CNTACTMS
Note In special cases, charges that are ordinarily incurred for support
calls may be canceled if a Microsoft Support Professional determines that a
specific update will resolve your problem. The usual support costs will
apply to additional support questions and issues that do not qualify for
the specific update in question.
If the issue persists, I suggest that you refer to the following article to
troubleshoot the issue:
842423 A call to the AuthzInitializeContextFromSid API function may fail
during
http://support.microsoft.com/?id=842423
If anything is unclear, feel free to let us know.
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Report Server refuse to send attachments
>thread-index: AcU55EU7XhajZL6GRdOem5RG403t2w==>X-WBNR-Posting-Host: 193.27.93.1
>From: =?Utf-8?B?QXZpc2hheSBCZW4tWnZp?= <Avishay@.community.nospam>
>Subject: Report Server refuse to send attachments
>Date: Tue, 5 Apr 2005 06:35:02 -0700
>Lines: 28
>Message-ID: <B9E0730C-23D5-411F-BFE9-B7846AF2DE57@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:40070
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>Hi,
>We recently encountered a problem with RS subscriptions: it suddenly
stopped
>sending attachmetns. Reports without attachments are sent without problems.
>The RSReportServer.Config is defined properly (including the <SMTPServer>
>and <From> properties.
>This is part of the error file:
>ReportingServicesService!library!3b2c!03/28/2005-12:01:20:: i INFO: Call
to
>RenderFirst( '/TNDReports/TicketCurrent' )
>ReportingServicesService!library!3b2c!03/28/2005-12:01:20:: e ERROR:
>Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
>The Report Server has encountered a configuration error; more details in
the
>log files, AuthzInitializeContextFromSid: Win32 error: 1355;
> Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
>The Report Server has encountered a configuration error; more details in
the
>log files
>I noticed there is something with a HotFix (number KB834859) but I could
not
>get to it.
>Server: Windows 2003 (Web server is seperated from database server)
>RS Service Pack 1 installed.
>SQL Server 2000 SP3a
>Thanks in advance,
>Avishay
>|||Hi,
We have exactly the same problem
First I switched the report server windows account to a domain user account
(as detailed in solution 2 below (found this while searching the net)
PROBLEM #1::
ReportingServicesService!libra­ry!878!04/19/2004-11:42:01:: e ERROR: Throwing
Microsoft.ReportingServices.Di­agnostics.Utilities.ServerConf­igurationErrorEx
ception: The Report Server has encountered a configuration error; more
details in the log files, AuthzInitializeContextFromSid: Win32 error: 1355;
Info:
Microsoft.ReportingServices.Di­agnostics.Utilities.ServerConf­igurationErrorEx
ception: The Report Server has encountered a configuration error; more
details in the log files
The key is the Win32 error 1355. This is a rights issue.
SOLUTION #1: The fix is to obtain from Microsoft hotfix #834859. This may
require opening a Support Call. Afte this was installed, that error went
away.
Still no reports being generated. Now we get a
different error when the email attachment is being processed for delivery.
PROBLEM #2:
ReportingServicesService!libra­ry!c10!02/25/2004-15:31:04:: e ERROR: Throwing
Microsoft.ReportingServices.Di­agnostics.Utilities.ServerConf­igurationErrorEx
ception: The Report Server has encountered a configuration error; more
details in the log files, AuthzInitializeContextFromSid: Win32 error: 5;
possible reason - service account doesn't have rights to check domain user
SIDs.; Info:
Microsoft.ReportingServices.Di­agnostics.Utilities.ServerConf­igurationErrorEx
ception: The Report Server has encountered a configuration error; more
details in the log files.
SOLUTION #2.
This second error was due to security issues. The Report Server NT Service
was running under the NT Authority\Network Service account. This account is
being seen by the domain controller when it makes the Authz call as an
anonymous user. So we need to change the account to a domain user account so
it will have sufficient privileges to make the Authz call this works since
their domain was a Windows 2000 domain and running in Mixed mode. To change
the Report Server NT Service account, we went through these steps.
1. Delete the references to the old key: rskeymgmt -r <installation id> (the
installation ID can be found in the rsreportserver.config file
2. Stop IIS and the Report Server windows service
3. Change the account service runs under
4. start IIS and the Report Server windows service
5. Reapply the encryption key: rskeymgmt -a -f <filename from step 1> -p
<password from step 1>
This didn't work so we installed Service Pack 1 for Windows2003 and it all
started working!
"William Wang[MSFT]" wrote:
> Hi Avishay,
> I believe the KB-article 834859 applies to the issue you are encountering.
> As mentioined in the KB 834859, there is a known issue that
> AuthzInitializeContextFromSid function passes a non-null-terminated string
> to the DsGetDcName function. Apparently this issue potentially cause
> problems when Windows report service tries to use this function. I've ever
> seen some customers have resolved the similar issues by installing the
> hotfix.
> To obtain the hotfix, please contact Microsoft Product Support Services.
> For a complete list of Microsoft Product Support Services phone numbers and
> information about support costs, visit the following Microsoft Web site:
> http://support.microsoft.com/default.aspx?scid=fh;[LN];CNTACTMS
> Note In special cases, charges that are ordinarily incurred for support
> calls may be canceled if a Microsoft Support Professional determines that a
> specific update will resolve your problem. The usual support costs will
> apply to additional support questions and issues that do not qualify for
> the specific update in question.
> If the issue persists, I suggest that you refer to the following article to
> troubleshoot the issue:
> 842423 A call to the AuthzInitializeContextFromSid API function may fail
> during
> http://support.microsoft.com/?id=842423
> If anything is unclear, feel free to let us know.
> Sincerely,
> William Wang
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> >Thread-Topic: Report Server refuse to send attachments
> >thread-index: AcU55EU7XhajZL6GRdOem5RG403t2w==> >X-WBNR-Posting-Host: 193.27.93.1
> >From: =?Utf-8?B?QXZpc2hheSBCZW4tWnZp?= <Avishay@.community.nospam>
> >Subject: Report Server refuse to send attachments
> >Date: Tue, 5 Apr 2005 06:35:02 -0700
> >Lines: 28
> >Message-ID: <B9E0730C-23D5-411F-BFE9-B7846AF2DE57@.microsoft.com>
> >MIME-Version: 1.0
> >Content-Type: text/plain;
> > charset="Utf-8"
> >Content-Transfer-Encoding: 7bit
> >X-Newsreader: Microsoft CDO for Windows 2000
> >Content-Class: urn:content-classes:message
> >Importance: normal
> >Priority: normal
> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> >Newsgroups: microsoft.public.sqlserver.reportingsvcs
> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> >Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> >Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:40070
> >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> >
> >Hi,
> >We recently encountered a problem with RS subscriptions: it suddenly
> stopped
> >sending attachmetns. Reports without attachments are sent without problems.
> >The RSReportServer.Config is defined properly (including the <SMTPServer>
> >and <From> properties.
> >This is part of the error file:
> >ReportingServicesService!library!3b2c!03/28/2005-12:01:20:: i INFO: Call
> to
> >RenderFirst( '/TNDReports/TicketCurrent' )
> >ReportingServicesService!library!3b2c!03/28/2005-12:01:20:: e ERROR:
> >Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
> ception:
> >The Report Server has encountered a configuration error; more details in
> the
> >log files, AuthzInitializeContextFromSid: Win32 error: 1355;
> > Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
> ception:
> >The Report Server has encountered a configuration error; more details in
> the
> >log files
> >
> >I noticed there is something with a HotFix (number KB834859) but I could
> not
> >get to it.
> >Server: Windows 2003 (Web server is seperated from database server)
> >RS Service Pack 1 installed.
> >SQL Server 2000 SP3a
> >
> >Thanks in advance,
> >
> >Avishay
> >
> >
>