SQL 2016 SSRS Data Sources folder is missing.

rwheeler23
rwheeler23 used Ask the Experts™
on
I am attempting to run an SSRS report on a brand new SSRS installation. I am getting this message:

"The current action cannot be completed. The user data source credentials do not meet the requirements to run this report or shared dataset. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified. (rsInvalidDataSourceCredentialSetting)
 "

When I try to look at the data sources in SSRS it is not there. I even tried servername/reports/browse/data sources and it tells me it is not there. I tried running repair on this instance of SQL and that did not help. What can I try to get the data sources folder back so I can check on the data sources under this instance of SSRS? There also is no Home icon and when I click Show Hidden Items nothing appears.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
President
Commented:
Something strange was going on here. I had originally installed SSRS as a domain user who was a sysadmin. I then deployed these reports that did not work. I then deleted all the reports and changed the data source to use 'sa' and SQL authentication. When I redeployed these reports suddenly there is the data sources folder and the reports work.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial