Hello,
Environment: Win2003 server SP1, IIS 6.0, SQL Server 2000 SP4, Reporting
services 2000 SP2.
Reporting services using account of sql server authentycation with logon
name of 'sa' and password.
Executing reports from manager working fine, but timed subscriptions failing
on execution with the following error: 'Logon failed'.
RS log file has the following messages:
e!notification!1094!05/11/2007-03:23:05:: e ERROR: Error occured processing
notification. Logon failed.
ReportingServicesService!notification!1094!05/11/2007-03:23:05::
Notification 63d3f301-ff48-4fc2-9697-578eaf02d5da completed. Success: False,
Status: Logon failed., DeliveryExtension: Report Server Email, Report: Batch
Inventory-tmp, Attempt 0
ReportingServicesService!dbpolling!1094!05/11/2007-03:23:05::
NotificationPolling finished processing item
63d3f301-ff48-4fc2-9697-578eaf02d5da
ReportingServicesServic
Dears, what caused notification problems:
is it problems with scheduled jobs or is it authentycation problems with SMTP?
How to see (or somehow extract) more detailed log from RS?
Thanks,
Andrius.Update:
Reporting services Unattended Execution Account using sql server
authentycation method with logon name of 'sa' and password.
"Andrius" wrote:
> Hello,
> Environment: Win2003 server SP1, IIS 6.0, SQL Server 2000 SP4, Reporting
> services 2000 SP2.
> Reporting services using account of sql server authentycation with logon
> name of 'sa' and password.
> Executing reports from manager working fine, but timed subscriptions failing
> on execution with the following error: 'Logon failed'.
> RS log file has the following messages:
> e!notification!1094!05/11/2007-03:23:05:: e ERROR: Error occured processing
> notification. Logon failed.
> ReportingServicesService!notification!1094!05/11/2007-03:23:05::
> Notification 63d3f301-ff48-4fc2-9697-578eaf02d5da completed. Success: False,
> Status: Logon failed., DeliveryExtension: Report Server Email, Report: Batch
> Inventory-tmp, Attempt 0
> ReportingServicesService!dbpolling!1094!05/11/2007-03:23:05::
> NotificationPolling finished processing item
> 63d3f301-ff48-4fc2-9697-578eaf02d5da
> ReportingServicesServic
> Dears, what caused notification problems:
> is it problems with scheduled jobs or is it authentycation problems with SMTP?
> How to see (or somehow extract) more detailed log from RS?
> Thanks,
> Andrius.
>
No comments:
Post a Comment