Hello, I have a problem with sending email from SQL Reporting. I have configured the subscription to send email with the attached report in PDF and the schedule. I can enter the text in Comment field. I can receive the email from SQL Reporting. The attached file (pdf file) is included in the email but I can't see the Comment I have configured in the email content.I have googled this but can't find any information about this. It's so strange to me. Anyone has faced this issue? Please help me how to fix this. Thanks, Thang

Hello Thang, Thank you to post your question to TechNet forum. This problem is so strange, and I consider that many people does not meet this kind of issue. In addition, I hope you can install the latest service package and cumulative update for SQL server, so that we can eliminate the existed problem of the service. In addition, on installing the patch, the issue could be fixed. In addition, please post out the configuration of the email settings on reporting service, and check whether there is any warning or error on the report server. It is possible that there is still warnings even though the report is sent properly. I hope it is helpful to you. If you have any questions about this issue, please let us know. Regards, EdwardEdward Zhu TechNet Community Support

Hello Edward, Thanks for your response. I could receive the email had the content before (2 or 3 weeks ago). Then I have tried with another report but the email now doesn't include content now. The SQL Server version is Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2) The SQL Reporting Services version is Microsoft SQL Server Reporting Services Version 9.00.3042.00. The below is the part of log file: ReportingServicesService!library!4!07/27/2012-03:00:42:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties. ReportingServicesService!library!d!07/27/2012-03:00:42:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties. ReportingServicesService!emailextension!11!07/27/2012-03:00:42:: Email successfully sent to "abc@abc.com" <abc@abc.com>, "cde@abc.com" <cde@abc.com> ReportingServicesService!notification!11!07/27/2012-03:00:42:: Notification 47842101-139a-465e-9901-fa80791f0d48 completed. Success: True, Status: Mail sent to abc@abc.com;cde@abc.com, DeliveryExtension: Report Server Email, Report: Issued_Payment_Receipts_Report, Attempt 0 ReportingServicesService!dbpolling!11!07/27/2012-03:00:42:: i INFO: NotificationPolling finished processing item 47842101-139a-465e-9901-fa80791f0d48 ReportingServicesService!emailextension!4!07/27/2012-03:00:42:: Email successfully sent to "abc@abc.com" <abc@abc.com>, "cde@abc.com" <cde@abc.com> ReportingServicesService!notification!4!07/27/2012-03:00:42:: Notification 0cc5dae4-9ed3-490f-80c8-35634ba8cd2a completed. Success: True, Status: Mail sent to abc@abc.com;cde@abc.com, DeliveryExtension: Report Server Email, Report: Issued_Payment_Receipts_Report, Attempt 0 ReportingServicesService!dbpolling!4!07/27/2012-03:00:42:: i INFO: NotificationPolling finished processing item 0cc5dae4-9ed3-490f-80c8-35634ba8cd2a ReportingServicesService!emailextension!d!07/27/2012-03:00:42:: Email successfully sent to "abc@abc.com" <abc@abc.com>, "cde@abc.com" <cde@abc.com> ReportingServicesService!notification!d!07/27/2012-03:00:42:: Notification 52828e18-002f-4e83-a2de-3749cc088234 completed. Success: True, Status: Mail sent to abc@abc.com;cde@abc.com, DeliveryExtension: Report Server Email, Report: Issued_Payment_Receipts_Report, Attempt 0 ReportingServicesService!dbpolling!d!07/27/2012-03:00:42:: i INFO: NotificationPolling finished processing item 52828e18-002f-4e83-a2de-3749cc088234 ReportingServicesService!dbcleanup!4!7/27/2012-03:06:14:: e ERROR: Sql Error in CleanExpiredSessions: System.Data.SqlClient.SqlException: Cannot resolve the collation conflict between "Latin1_General_CI_AS_KS_WS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.DatabaseSessionStorage.CleanExpiredSessions() ReportingServicesService!library!4!7/27/2012-03:06:14:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams ReportingServicesService!dbcleanup!4!7/27/2012-03:16:14:: e ERROR: Sql Error in CleanExpiredSessions: System.Data.SqlClient.SqlException: Cannot resolve the collation conflict between "Latin1_General_CI_AS_KS_WS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.DatabaseSessionStorage.CleanExpiredSessions() ReportingServicesService!library!4!7/27/2012-03:16:14:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams ReportingServicesService!dbcleanup!f!7/27/2012-03:26:14:: e ERROR: Sql Error in CleanExpiredSessions: System.Data.SqlClient.SqlException: Cannot resolve the collation conflict between "Latin1_General_CI_AS_KS_WS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.DatabaseSessionStorage.CleanExpiredSessions() I have changed email addresses in the content of the log file. I think the log file is normal. I don't see any warnings/errors relate to email. Could you let me know what the latest version of SQL Server 2005 and SQL Reporting Services are? Do I have any problems with log file? Thanks, Thang

IT team installed QChain to the web server. I suspect it is the root cause. We have restarted the Reporting Services and it works normally. Thank Edward Zhu for your investigation. Thang,