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
> >
> >
>

Report Server (MSSQLSERVER) cannot connect to the report server database.

I was viewing some reports, and it suddenly showed me that error, from Reporting Services Configruation I restarted the service but nothin, that s the error show on event log.

What else can I Do?

I also see this on the event log.

La configuración de permisos que depende de la aplicación no concede permiso de activación local para la aplicación de servidor COM con CLSID

{BA126AD1-2166-11D1-B1D0-00805FC1270E}

al SID (S-1-5-20) de NT AUTHORITY\Servicio de red del usuario. Este permiso de seguridad se puede modificar mediante la herramienta administrativa Servicios de componentes.

Para obtener más información, vea el Centro de ayuda y soporte tcnico en http://go.microsoft.com/fwlink/events.asp.

|||Take a look at this previous post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=399539&SiteID=1

Report Server (MSSQLSERVER) cannot connect to the report server database

I am running SQL Reporting Services and SQL Server 2005 on a Windows 2003 server. The configuration has been unchanged for approx. 3 weeks. Suddenly today, reports being accessed via an ASP.NET 2.0 application (on Windows 2003 Server with IIS 6) using a SOAP call to the reportserver became inaccessable. End users received the following error:

Message: An error occurred during rendering of the report. >
An error occurred during rendering of the report. >
An error occurred during rendering of the report. >
An error occurred during rendering of the report. >
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

Stack Trace: at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at IFA.CAP.SQLReportingService.ReportingService.Render(String Report, String Format, String HistoryID, String DeviceInfo, ParameterValue[] Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle, String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings, String[]& StreamIds) in C:\Applications\IFACAP\Web References\SQLReportingService\Reference.vb:line 1319
at IFA.CAP.BusinessObjects.Reports.Certificate(Int32 certificateID, Boolean isDraft, Boolean isCertified) in C:\Applications\IFACAP\BusinessObjects\IFA.CAP.BusinessObjects.Report.vb:line 551
at IFA.CAP.CertificateDetail.PrintCertificate(Object sender, EventArgs e) in C:\Applications\IFACAP\Main\CertificateDetail.aspx.vb:line 2287

Subsequently, the following error is logged on the Report Server/Database server:

Report Server (MSSQLSERVER) cannot connect to the report server database.

I was able to temporarily correct the problem by performing as iisrest on the Report Server/Database server. However, the same problem occured again a couple hours later. I am relatively new to SQL Reporting Services so any help would be appreciated.

MDJ

Well, the "Report Server (MSSQLSERVER) cannot connect to the report server database" error seems to have vanished but I am still receiving the "Message: An error occurred during rendering of the report. >
An error occurred during rendering of the report. >
An error occurred during rendering of the report. >
An error occurred during rendering of the report. >
Attempted to read or write protected memory. This is often an indication that other memory is corrupt." error. Once whatever is causing this problem occurs, all users attempting to access SSRS from our ASP.NET application (using SOAP) receive the aforementioned error.

I have tried the following:

1. increased the MaxActiveReqForOneUser element in the RSWebApplication.config

2. Set the AppPool recycling setting for the ReportServer to run only once at a specified time (thinking perhaps the pool was recycling and corrputing session information).

Things I've noticed:

So far the only resolution for this issue is to perform an iisrest on the ReportServer.

This only seems to be an issue with reports being called using SOAP. Reports being rendering in the .NET Report Viewer control appear unaffected.

Here is some sample code to illustrate how we call some of our reports from ASP.NET through the SSRS web service:

************************************************************************************************************************************

Private callback As New System.Net.Security.RemoteCertificateValidationCallback(AddressOf RemoteCertificateValidationCallback)

Private Function RemoteCertificateValidationCallback(ByVal sender As Object, _
ByVal cert As System.Security.Cryptography.X509Certificates.X509Certificate, _
ByVal chain As System.Security.Cryptography.X509Certificates.X509Chain, _
ByVal sslPolicyErrors As System.Net.Security.SslPolicyErrors) As Boolean

Return True

End Function

Sub RenderReport()
Dim rs As New SQLReportingService.ReportingService
Dim results As [Byte]() = Nothing

System.Net.ServicePointManager.ServerCertificateValidationCallback = callback

rs.Credentials = New System.Net.NetworkCredential("User", "Password", "Domain")

results = rs.Render(String.Concat("TargerFolder", "ReportName"), "PDF", Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing)

Response.Clear()
Response.Buffer = True
Response.Expires = 0
Response.ContentType = "application/pdf"
Response.AppendHeader("Content-Disposition", "attachment; filename=Report.pdf")
Response.BinaryWrite(results)
Response.End()
End Sub

**********************************************************************************************************************************************

Does anyone see a problem with the above code. It has been in production for 3 weeks now and has been working fine until yesterday. Any help would be greatly appreciated!