SSRS Report Credential Error

Question

SSRS Report Credential Error

Raju Kothapally 10

SSRS report works initially but fails after 10–15 minutes of idle time.

When user clicks Next page, Print, or Download, the report throws error:

"Credentials have not been supplied for a data source used by the report."

The report is generated using Microsoft SQL Server Reporting Services (SSRS)

and is embedded in a CRM application.

Issue occurs during report re-execution (pagination/export)

and is related to authentication handling in SSRS.

1 answer

Your answer

Answer 1

The issue you are experiencing with SSRS reports throwing a "Credentials have not been supplied for a data source used by the report" error after a period of idle time is likely related to the authentication handling in SSRS. When a report is initially run, it may have valid credentials, but after a period of inactivity, those credentials may no longer be valid or may not be retained for subsequent actions like pagination, printing, or downloading.

To resolve this issue, you can consider the following options:

Use Stored Credentials: Ensure that the data source for your report is configured to use stored credentials instead of relying on Windows authentication. This can help maintain the necessary credentials for the duration of the report session.
Configure Unattended Execution Account: If your report server is configured to use an unattended execution account, ensure that it is set up correctly. This allows the server to run reports without needing user credentials every time.
Modify Data Source Settings: Check the data source settings in the Report Manager. Ensure that the connection string does not have Integrated Security=True, as this can lead to issues when the report is re-executed after being idle.
Session Timeout Settings: Review the session timeout settings in your CRM application and SSRS to ensure that they are set appropriately to prevent session expiration during idle times.

By implementing these changes, you should be able to mitigate the credential error when users attempt to interact with the report after a period of inactivity.

References:

Akhil Gajavelly 1,130 Reputation points Microsoft External Staff Moderator

2026-01-12T04:39:03.3433333+00:00

Hi @Raju Kothapally ,

This is expected SSRS behavior for embedded reports. After idle time, SSRS loses the user token and fails during re-execution (Next page / Export / Print).

To fix this, configure the report data source to use Stored Credentials (SQL or service account). Avoid Integrated Security=True for embedded SSRS reports.

If stored credentials aren’t allowed, configure the Unattended Execution Account.

This resolves the error works for pagination/export after idle time.

Thanks,
Akhil.
Akhil Gajavelly 1,130 Reputation points Microsoft External Staff Moderator

2026-01-21T05:00:54.8333333+00:00

Hi @Raju Kothapally ,

Just checking back did configuring stored credentials (or the unattended execution account) resolve the SSRS credential error after idle time?

If yes, please mark the solution that worked so others facing the same issue can benefit. If not, let us know your data source authentication type and how the report is embedded, and we can dig further.

Thanks,
Akhil.

Share via

SSRS Report Credential Error

1 answer

Your answer