Well, I only use Reporting Services (RS) with Team Foundation server (TFS) as yet, but blieve me either the integration of RS with TFS is not good or there is some great problem with RS. It create lots of problems, some days back when we move our server from WorkGroup to Domain. We start getting this error. TfsOlapReportDS Report Service ErrorSo, as usual it requires much try and lots of efforts to solved. I attemp following procedure to get ridd of it.
Try 11. Open SQL Server Management Studio 2. Select Analysis Services from Server type3. Select your server. It will connect you and will show you object explorer.4. Drill Down to the database you will find TfsWarehouse 5. Select Roles - > Select TfsWarehouseDataReader6. A property popup will appear, Select Membership from the left panel.7. Verify that TFS Service account is listed here, as well as all the users who have access to the reporting services of TFS are listed here (Users might be in groups).
Try 21. Connect to http://reportserver/reports2. Click TfsOlapReportDS3. Check Enable this data source4. Select Connection Type to Microsoft Analysis Services 5. Verify the Connection string which is entered is correct, if it is not there. write it. Data source=name;initial catalog=TfsWarehouse6. Select Credentials stored securely in the report server and Add TFS Service Account user and password here. 7. Check "use as Windows credentials when connecting to the data source".8. Click Apply.
Both the tricks, didn't work really so I move to Event Log and there is another issue. Windows is regularly logging an error called
Microsoft.TeamFoundation.VersionControl.Adapter: Unable to access the following folder: C:\\Program Files\\Microsoft Visual Studio 2008 Team Foundation Server\\Web Services\\Warehouse\\VersionControl_Data
So to solve this issue
Try 31. Go to C:\\Program Files\\Microsoft Visual Studio 2008 Team Foundation Server\\Web Services\\Warehouse2. See if you have any folder with the name of "VersionControl_Data".3. If there is not any folder then create one and Grant Read / Write Access to the TFS Service Account.
In my case the folder was not there, so I create one and Error Logging disappears. Atleast TFS is running fine but still the issue of Reporting Services is there. So I went back to the reporing portal
Try 41. Connect to http://reportserver/reports2. Click TfsReportDS3. Check the same thing which we had for "TfsOlapReportDS" except that it will connect to Microsoft Sql Server rather Analysis Services. 4. In my case the connection string was empty, I just fill that Data source=name;initial catalog=TfsWarehouse5. Please make sure to re-enter password at the bottomg of page, as it gets expires when you change any thing in the form and press submit without entering the password again.
So, These four attempts restore our Reporting services from this error. Also, note in most of the cases when reporting services is not working fine, you will not be able to create new project in Team System. Don't take Reporting Services lightly, It is really important for Team System
