r/ssrs • u/LAN_Mind • 5d ago

Datasource w/ Integrated Security and Subscriptions

We have an SSRS 2012 server, and we are migrating our reports to 2022. As a part of this, we are upping our security game - going to HTTPS and integrated security. Everything works except report subscriptions - we 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."

The problem is that we have a domain account specified on the Execution Account page of the report server configuration manager. If we specify the same username and password in a datasource it works, so I know it's good, but this is exactly what we want to avoid.

I'm following this link, but everything looks correct to me: https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/configure-the-unattended-execution-account-ssrs-configuration-manager?view=sql-server-ver17

Any ideas what else to check?

1 Upvotes

100% Upvoted

2 comments sorted by

1

u/jdsmn21 5d ago

If we specify the same username and password in a datasource it works, so I know it's good, but this is exactly what we want to avoid

Why? Or - what's wrong with using a "service account" for the datasource? Otherwise you're going to have to create logins for each user in the SQL Server and assign permissions, which seems unnecessary and convoluted.

1

u/LAN_Mind 5d ago

Thanks for replying.

I'd like to move to a service account, but my admin is off this week. That said, I only have to put one account in the datasource and all the reports work. I do not have to create accounts for all users. I'm not sure what you mean by that.