SQL Server Reporting Services中的定时订阅(Timed subscriptions in SQL Server Reporting Services)

SQL Server Reporting Services中的定时订阅(Timed subscriptions in SQL Server Reporting Services)

我们正在运行SQL Server报告服务。 我们有多个定时订阅，现在已经停止工作，因为突然删除了Active Directory用户。

完成一些研究后，所有内容都指向将作业所有者更新为有效的AD用户，然后成功运行。 但是，如果创建了新订阅，我们将旧AD用户作为所有者。

除了每次创建或更新作业时都使用新AD用户手动更新作业，是否有办法永久性地使用新广告用户来解决此问题？

提前致谢。

We are running SQL Server reporting Services. We have multiple timed subscriptions which have now stopped working as the Active Directory user has suddenly been deleted.

Having done some research everything points to updating the owner of the job to a valid AD user, Which then works successfully. However if a new subscription is created we get the old AD user as the Owner.

Apart from manually updating the Job with the new AD user each time the job is created or updated, is there a way to fix this permanently going forward with the new Ad user ?

Thanks in advance.

最满意答案

我认为您在Reporting Services配置管理器数据库设置中使用旧AD用户的凭据。

转到Reporting Services Configuration Manager选择“ Database选项卡，在“ Current Report Server Database Credential我建议您设置服务帐户以避免再次出现此问题。

I think you are using the credentials of the old AD user in the Reporting Services Configuration Manager Database settings.

Go to Reporting Services Configuration Manager select the Database tab, in Current Report Server Database Credential I recommend you set a Service Account to avoid this issue occur again.