Query execution failed for data set 'dsLastProcessedTime'.
To resolve this problem, you need to do the following:
- Go to the following Address http://server/Reports
- Select the Data Source TfsOlapReportsDS
- Check the option 'Enable This Data Source'
- In Data Source Type, select 'Microsoft SQL Server Analysis Services'
- In Connection String, write 'Data source=[servername]; initial catalog=TfsWarehouse' (without ')
- Check 'Credentials stored securely in the report server', and type the user name [domain\user] and the password for the user in the domain who has access to the server of analysis Services.
- Check 'Use as Windows Credentials ...' and 'Impersonate the authenticated user...' and click the botton Apply.
After that, do the same for the Data Source TfsReportDS, with the following exceptions
- In the Data Source Type, select Microsoft SQL Server.
- In the Connection String write 'Data Source=[servername]; initial catalog=TfsWarehouse'.
Use the same configuration used in the Data Source TfsOlapReportDS.
With that, the reports should be showed again.
No comments:
Post a Comment