How do I fix the TfsOlapReportDS user problem?

How do I fix the TfsOlapReportDS user problem?

• None01

  Hi Gary,

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

  thanks!

  mauli

  
  

• William Bartholomew

  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

  
  

• Patty C

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

  Pete

  
  

• GroZZleR

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

  Regards,

  Gary

  
  
  

• Aoeuid

  >> 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

   

   

   

  
  

• stonejc

  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

  
  

• Nishant Sivakumar

  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

  
  

• Daniel Hardjosuwito

  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.
  
  

• Kushu

  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

  
  

• Jeff Williams

  thx Mauli, did it!
  

• Keith Brown

  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

  
  

• Hooper

  You have to add the TFSREPORTS Account as local Admin to the application tier server. This will solve the problem.
  
• How do I fix the TfsOlapReportDS user problem?