How do I fix the TfsOlapReportDS user problem?

Question

I am currently unable to run any TFS reports.

The error message is:

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'TfsOlapReportDS'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors


Is it possible to delete and recreate the 'TfsOlapReportDS' user account?

Answer 1

Hi Gary,

To get more information about the error, on the report server machine, navigate to http://localhost/reports and then click on a report.  Then we'll be in a better position to know how to proceed.

I am not sure what you mean about delete/recreate the TfsOlapReportDS user account.  You can modify the user account that is being used to connect to the warehouse. 

1. Navigate to http://<reportserver>/reports
2. There should be two items called "TfsOlapReportDS" and "TfsReportDS" present on this web page with the Data Source icon next to them.
3. Click on TfsOlapReportDS.
4. On this page, you can modify the user account that connects to the olap cube.  -- make sure that this user account is a member of the TfsWarehouseDataReader role on the TfsWarehouse cube.

let me know if that helps!

mauli

Answer 2

Hello Mauli,

To recreate the problem:
- navigate to http://localhost/reports
- select Team Project called SIDES
- select Work Items report

Observe the following error message:

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'TfsOlapReportDS'. rsErrorOpeningConnection)
The connection string is not valid.

Answer 3

>> 4. On this page, you can modify the user account that connects

>> to the olap cube.  -- make sure that this user account is a member of the

>> TfsWarehouseDataReader role on the TfsWarehouse cube

 

How do I make sure that TfsOlapReportDS is a member of the TfsWarehouseDataReader role on the TfsWarehouse cube?

 

 

 

Answer 4

hi gary,

can you navigate to the TfsOlapReportDS and verify that the connection type is "Microsoft SQL Server Analysis Services" and the connection string is like this: "Data source=<DataTierName>;initial catalog=TfsWarehouse"

The user account credentials provided to this data source needs to be a part of the TfsWarehouseDataReader role on the cube.  You can see which user account you're providing to the data source by following the directions in the post. 

To check what user accounts are part of the TfsWarehouseDataReader role:

1. Connect to Analysis Services on the data tier using SQL Server Management Studio.
2. Click on "Databases" to expand that node. -- TfsWarehouse should be a child.
3. Click on "Roles" - TfsWarehouseDataReader should be a child.
4. Right click on TfsWarehouseDataReader and select Properties.
5. Click "Membership" -- you should see the members of this role.

mauli

Answer 5

Hi Gary,

Were you able to resolve this problem? please let me know if i can help further.

thanks!

mauli

Answer 6

Hi Mauli,

  Im having similar problems.  I verified everything posted and I still have the same error mentioned by the original owner.  What else needs to be checked?

The reports worked fine in Beta3, but once we upgraded to RTM they havent worked.

 

Please help

 

Thanks,
Staffan

Answer 7

Hi Staffan,

Just so that I'm sure that we've walked through everything, I"ll just detail out the steps again - could you provide me with your results?

The error:

1. On the report server machine, navigate to: http://localhost/reports
2. Click on a project folder.
3. Click on Related Work Items report.

 -- are you getting this error?

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'TfsOlapReportDS'. rsErrorOpeningConnection)
The connection string is not valid.

Verify the data source:

1. Navigate to http://<reportserver>/reports
2. There should be two items called "TfsOlapReportDS" and "TfsReportDS" present on this web page with the Data Source icon next to them.
3. Click on TfsOlapReportDS.
4. Is "Enable this data source" marked?
5. Is the connection type "Microsoft SQL Server Analysis Services" ?
6. Is the connection string like this?  "Data source=<DataTierName>;initial catalog=TfsWarehouse"
7. Is "Credentials stored securely in the report server" marked?
8. Is "Use as Windows credentials when connecting to the data source" marked?
9. Enter in the password for the user connecting to the data source again, just to verify it's correct. Click Apply.

Verify the account has access to the cube:

The user account credentials provided to TfsOlapReportDS needs to be a part of the TfsWarehouseDataReader role on the cube. 

1. Connect to Analysis Services on the data tier using SQL Server Management Studio.
2. Click on "Databases" to expand that node. -- TfsWarehouse should be a child.
3. Click on "Roles" - TfsWarehouseDataReader should be a child.
4. Right click on TfsWarehouseDataReader and select Properties.
5. Click "Membership"
• Is the user account used in the data source a member of this role?

Please let me know the answers to these questions then we can determine how to proceed.

Thanks,

mauli

Answer 8

Hello Mauil,

I'm also having the same problems and it started all of a sudden. I've had access to the reports for months and now I get the said error message.

I've ran through your suggestions on this post but to no avail.   If anyone else has experienced this problem and found a solution, that would be helpful.

Thanks,

Devin

Answer 9

thx Mauli, did it!

Answer 10

I saw no databases at all in step 2 of "Verify the account has access to the cube"

 

Pete

Answer 11

Remember an IISReset will resolve any broken connections IIS is holding, assuming them valid.

 

Regards,

Gary

 

Answer 12

 

You have to add the TFSREPORTS Account as local Admin to the application tier server. This will solve the problem.

Answer 13

Instead of elevating the permissions for TFSREPORTS Account by adding it to local admins group, make sure that the TFSREPORTS Account has "Allow log on locally" permission (Control Panel > Administrative Tools > Local Security Settings).

Answer 14

I had the same problem which was not solved by the "Allow log on locally" fix until I removed the same account from "Deny log on locally" !!!!

Hope this helps.

Matt

Answer 15

thanks for your excellent description regarding Report generation problem.


ankarao

Answer 16

I am facing same problem while running the reports and also reports node is red crossed in team explorer I did the everything and checked all the mentioned area everything is seems ok but still have problem.


Due to that I am not able to create a new team project and also not able to run the TFS admin tool.

---

verma