Hi arkiboys,
Just as the error message said, we should use stored credentials security in the report server to connect to data source. When a report runs as a background process, the report server is the agent that executes the report. Because there is no user context in place, the report server must get credential information from the report server database in order to connect to a data source. SSRS requires a Login to connect to the data source to process the report when subscription will be occurring at its scheduled time.
To set the stored credentials in report server, please see the following steps:
- Report>Properties> Click on the Data Sources tab and you will see following options:
- A shared data source
- A custom data source
- Select second one, then click on option “Credentials stored securely in the report server” and provide credential information.
- Check the “Use as Windows credentials when connecting to the data source”, we also need to click the Apply the apply the setting to the relevant report, otherwise, the setting we specified would be canceled.
Besides, we can also using the shared data source which is having credential saved into report server.
If there are any other questions, please feel free to ask.
Thanks,
Katherine Xiong
If you have any feedback on our support, please click here.
Katherine Xiong
TechNet Community Support
No comments:
Post a Comment