Hello,

On one server I have an issue with reporting Services:

Thanks,

Dom

• An error has occurred during report processing. (rsProcessingAborted)
  • Cannot impersonate user for data source '{5C6358F2-4BB6-4a1b-A16E-8D96795D8602}'. (rsErrorImpersonatingUser)
    • Logon failed. (rsLogonFailed)
      • For more information about this error navigate to the report server on the local server machine, or enable remote errors

Yes SQL is on another server

SCCM on ServerA

SQL on Server B

SSRS on Server B as well

Thansk,

Dom

SCCM:

Data Source Authentication

Credential stored securely in the report server

User name.....

Password

Use as Windowas Windows credentials when connecting to the data source

 Data Source Security

A list of accounts are listed including the User name listed above.

SSRS:

same on SQL Server Reporting Services Prop

It is a SQL User ID or Windows ID that you are using to access the database? 

Windows ID from Active Directory.

it could be a Service Account, it is the one defined in SSRS and in SSCM Authentication or it could be a Windows NT Account from a user...

 Windows Server 2003 Standard x64 Edition Service Pack 2

Microsoft SQL Server 2005

On the SQL Server:

- Browse Home.aspx works with any accounts listed... from the IIS > Web Sites > Default Web Site > Reports

- http://locahost/ReportServer works

but when trying to drill down to the report execution it si failing with the same error a before..

 I noticed that even the datasource is set to "CVredentials stored securely in the report server" each report is using "Credentials supplied by the user running the report ... it is strange... and it is grayed out not updatable!!!

 but it is the same on the server where SSRS is w

Try this.. Is it Successful?

http://tinyurl.com/3dq6hvr

Cannot impersonate user for data source '{5C6358F2-4BB6-4a1b-A16E-8D96795D8602}'. (rsErrorImpersonatingUser)

•  
  •  
    • Logon failed. (rsLogonFailed)

Hi,

Could you try to use "Impersonate the authenticated user after a connection has been made to the data source" and see the result.

Yes this option load te report... is it correct to leave it as is ?

the reports look empty so far even when the SCCM reports have data!!!!

Thanks,

Yes 10 checked already - especially the one I was looking for (:

- Count SMS Client Versions

- Computers not inventoried recently

- Computer information for a specific computer

- Computer in a specific site

- Count processor speeds

etc...

I saw some of them filled up and working normal

The report displays the header report name,  report folder ... the report ran on 9/21/2011 2:45:13 PM ... 1

but nothing else... if I run it in SCCM it has 79 rows...

Hi,

Are they OK using classic web report ? If, so can you do a test : remove one of them and copy it again to SRS.

Hello,

they are okay only with System Center Configuration Manager > Site Database > Computer Managment > Reporting > Reports

There are not okay with System Center Configuration Manager > Site Database > Computer Managment > Reporting > Reporting Services

There are not okay with http://Servername/reports

I removed " Count SMS Client versions" and copy it again and it works now!!!

the overwrite did not...

let me try on all reports...

Thanks,

yes it works also...

Yes it works for all reports tested so far

Any explanation?

Thanks,

Dom

Hello,

Apparently this setting do not authorise subscription, am I right I am getting an error:

Thanks,

That is because you have "Impersonate the authenticated user after a connection has been made to the data source" enabled... There are no users logon when the report runs... uncheck this option. Also make sure that you have enable the account to have db reader in SQL.

Hello,

they are okay only with System Center Configuration Manager > Site Database > Computer Managment > Reporting > Reports

There are not okay with System Center Configuration Manager > Site Database > Computer Managment > Reporting > Reporting Services

There are not okay with http://Servername/reports

I removed " Count SMS Client versions" and copy it again and it works now!!!

the overwrite did not...

let me try on all reports...

Thanks,

Hi,

Where can I find the option "Impersonate the authenticated user after a connection has been made to the data source"

Where can I find the option "Impersonate the authenticated user after a connection has been made to the data source"