无法创建 SSRS 报告订阅
我无法创建 SSRS 报告的订阅，因为它给出以下错误：
无法创建订阅，因为用于运行的凭据 报告未存储，或者如果有链接报告，则链接不存在 有效期更长。
我的设置如下：
ServerA - 数据库服务器
ServerB - 报告服务器
MachineC - 用于查看报告的 Internet Explorer
因此，我正在计算机 C、IE 上查看报告，ServerB 连接到 ServerA 获取数据源。
I am not able to create subscriptions for SSRS reports as it gives the following error:
Subscriptions cannot be created because the credentials used to run
the report are not stored, or if a linked report, the link is no
longer valid.
My set up is as following:
ServerA - Database Server
ServerB - Report Server
MachineC - Internet explorer to view the reports
So I am viewing reports on Machine C, IE, and ServerB connects to ServerA for Datasource.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
该问题听起来像是报告希望用户在查看报告时提供凭据。当您创建订阅时，它没有执行报告的凭据。
转到报告，单击属性选项卡，然后在左侧窗格中选择数据源。
您使用共享数据源吗？是否使用 Windows 集成安全性？如果是这样，您可以将其更改为使用专门为运行这些报告而创建的服务帐户吗？您可能需要通过查看数据源本身来查看这些属性。
如果是自定义数据源，是否选择了“运行报告的用户提供的凭据”选项？如果是这样，您可以将其更改为“安全地存储在报表服务器中的凭据”吗？
无论哪种方式，如果您想设置订阅，我都会通过在数据源中提供凭据而不是让用户输入它们来使其工作。
如果您担心安全性，我建议在报告级别而不是数据源级别进行管理。
The problem sounds like the report expects the user to provide credentials when it is viewed. When you create a subscription, it does not have the credentials to execute the report.
Go to the report, click the properties tab, then choose Data Sources in the left pane.
Are you using a shared data source? Is it using Windows integrated security? If so, can you change it to use a service account made just to run these reports? You may need to view these properties by viewing the data source itself.
If it is a custom data source is the option "Credentials supplied by the user running the report" selected? If so, can you change it to "Credentials stored securely in the report server"?
Either way, if you want to set up a subscription, I have made it work by providing credentials in the data source rather than have the user input them.
If you are worried about security, I would suggest managing that on the report level rather than the data source level.
该错误没有说明的是，为了能够订阅报表，不仅必须将数据源设置为“安全地存储在报表服务器中的凭据”，而且还不得选择“在之后模拟经过身份验证的用户”选项。已与数据源建立连接”。
What the error does not make clear is, in order to be able to subscribe to a report not only must the data source be set to "Credentials stored securely in the report server" you must also not select the option "Impersonate the authenticated user after a connection has been made to the data source".
我所做的方法是在报告生成器中创建一个新的数据源，并明确提供要使用的用户名和密码。
然后，在报告中使用该用户名密码和新数据源，瞧，它成功了。
The way I did was to create a new data source in the report builder and explicitly provided the username and password there to be used.
Then, used that username password with the new data source with the report and voila it worked.
我遇到了与您相同的问题，并且我找到了它的解决方案，正如 @richard 所说，它与您用于部署报告的数据源的凭据有关。
要解决该问题，请按照下列步骤操作：
1. 右键单击您在部署的报告中使用的共享数据源。
2. 单击编辑按钮。
3. 将打开一个新窗口，单击左侧窗格中的“凭据”，选择“使用此用户名和密码”，然后单击“确定”。
4. 选中您在上一屏幕上看到的保存这些凭据选项。
5. 测试连接，如果成功，请单击“确定”并将项目部署到报表服务器上。
作为参考，请查看下面给出的屏幕截图：
谢谢。
I faced same issue as you, and i found its solution, as @richard said already that it is related to credential of data source you use for your deployed report.
To resolve it Follow these steps:
1. Right click on your shared Data source which you use in your deployed report.
2. Click On Edit Button.
3. a new window will open click on Credential from left pane, Select Use this user name and password then click ok.
4. Check on Save these credential option you get on to previous screen.
5. Test connection and if succeed click ok and deploy your project on report server.
For reference plese look at screen shot given below:
Thanks.