Hi,
Background - reinstalled sql and tfs but could not remember the password for the reporting services encryption key. I deleted the key and now am trying to add in all the bits that I am missing.
I have added the datasources with connection string "Data source=TFS;initial catalog=TFSWarehouse" and set the data source type to Microsoft SQL Server Analysis Services and Microsoft SQL Server for TfsOlapReportDS and TfsReportDS respectively. I also still have the role TfsWarehouseDataReader set up for both Microsoft SQL Server Analysis Services and Microsoft SQL Server. The securables section for TfsWarehouseDataReader in Microsoft SQL Server is blank if that makes any difference.
After entering these details I am still getting the following error when trying to view a report:
- An error has occurred during report processing. (rsProcessingAborted)
- Cannot create a connection to data source 'TfsReportDS'. (rsErrorOpeningConnection)
- Login failed for user 'MyDomain\tfsreports'.
And also in the event log is the error:
Event Type: Failure Audit Event Source: MSSQLSERVER Event Category: (4) Event ID: 18456 Date: 4/09/2006 Time: 2:44:12 PM User: MyDomain\tfsreports Computer: TFS Description: Login failed for user 'MyDomain\tfsreports'. [CLIENT: <local machine>]
If anyone has any ideas that would be great. I am sure its something simple but I just don't have a working TFS RS to use as a reference at the moment.
Thanks heaps.
Visual Studio Team System2
|