Share via

creating subscription for SCOM Audit Reports throws error

Carl94580345 41 Reputation points
2025-10-24T19:50:15.99+00:00

On the SSRS for SCOM ACS the Audit Reports, running SQL 2022 CU20

When I try to create a subscription I get the error “Subscription can't be created or edited because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid.”

When I click on a data source I get the error “Something went wrong. Please try again later.”

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Azar 30,735 Reputation points MVP Volunteer Moderator
    2025-10-25T20:58:26.9033333+00:00

    Hi there Carl94580345

    when the data source credentials aren’t properly stored or are set to “Prompt for credentials” rather than “Stored securely in the report server.” In SSRS, subscriptions require that the report can run unattended, so credentials must be saved. I’d suggest:

    Go to Report Manager or SSRS Web Portal.

    Open the report properties → Data Sources.

    Ensure the data source is using “Credentials stored securely in the report server” and provide a valid SQL login.

    If it’s a shared data source, make sure the shared source has credentials stored as well.

    After updating, try creating the subscription again.

    If this helps kindly accept the answer thanks much

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.