cancel
Showing results for 
Search instead for 
Did you mean: 

Discovery accelerator cannot create Report

Idriss_Ali
Level 4
Partner

Hi,

when i am creating a case report i got the below error, i am using the same ev user for DA server and Client:

System.Web.Services.Protocols.SoapException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot impersonate user for data source 'CustomerDatabase'. ---> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Log on failed. Ensure the user name and password are correct. ---> System.ComponentModel.Win32Exception: The user name or password is incorrect
   at Microsoft.ReportingServices.Library.ReportingService2005Impl.CreateItemHistorySnapshot(String Report, Guid batchId, String& HistoryID, Warning[]& Warnings)
   at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateReportHistorySnapshot(String Report, String& HistoryID, Warning[]& Warnings)

 

1 ACCEPTED SOLUTION

Accepted Solutions

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

looks like an issue with the account you use for sql reporting in DA. might be easiest to redeploy the reports or you can start digging around with the accounts, permissions, and databases in sql/srs 

View solution in original post

5 REPLIES 5

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

looks like an issue with the account you use for sql reporting in DA. might be easiest to redeploy the reports or you can start digging around with the accounts, permissions, and databases in sql/srs 

View solution in original post

Idriss_Ali
Level 4
Partner

i recreated the reports but i got the below 

System.Web.Services.Protocols.SoapException: The current action cannot be completed. The user data source credentials do not meet the requirements to run this report or shared dataset. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidDataSourceCredentialSettingException: The current action cannot be completed. The user data source credentials do not meet the requirements to run this report or shared dataset. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified.    at Microsoft.ReportingServices.Library.ReportingService2005Impl.CreateItemHistorySnapshot(String Report, Guid batchId, String& HistoryID, Warning[]& Warnings)    at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateReportHistorySnapshot(String Report, String& HistoryID, Warning[]& Warnings)

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

You probably didn't configure the dataset's execution account.

Configure the Unattended Execution Account

Check this thread: Error scheduling report

Idriss_Ali
Level 4
Partner

 

the issue was the reports was not uploaded succsessfully, after i upload the reports it wroked fine

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

ok great so redeploying the reports was the solution afterall. thanks for the update.