creating subscription for SCOM Audit Reports throws error

Question

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.”

Answer 1

Hi Carl94580345,

May be the linked reports is pointing to a broken or missing source. It could be using prompted credentials or Windows authentication, which SSRS subscriptions do not support.

Check if Audit & Audit5 are linked reports. Go to SSRS Web Portal → Manage → General tab.
If it says “This is a linked report,” then the original report may have been moved or deleted.
Recreate the report or re-link it to a valid source.

If you still can't access the data source due to the “Something went wrong” error, then try accessing it via Report Builder or Visual Studio.

Hope this helps!

Answer 2

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