Home / Announcements / Forums / TFS Work Item Manager and Project Dashboard: TFS Project Dashboard > Either the user, <username>, does not have access to the Tfs_Analysis database, or the database does not exist.

• Vivid Group

  Posted on Apr 6, 2011 (permalink)

  Hi there,
  
  Testing out the Project Dashboard on several machines and getting this error for some of the widgets (e.g. Team Velocity).
  
  I have made the user in question, Team Foundation Content Manager permisions in Report Server and the user can view http://tfs/Reports/<projectname>/ and all reports. So not sure how to resolve the issue?
  I have also made this user "Project Administrator" in TFS Security for the project but it did not have effect?
  
  Is there any other areas I need to look at in applying security permissions?
  
  Stack Trace is:
  

  at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.ExecuteMultidimensional(ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)

     at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteCellSet()

     at IRC.Gear.WorkItemManager.Dashboard.TfsDataProvider.TfsWarehouse.RetrieveRemainingWorkData(String projectName, Boolean isScrumProcess, IterationInfo currentIteration, TfsVersion tfsVersion)

     at IRC.Gear.WorkItemManager.Dashboard.TfsDataProvider.TaskDataProvider.GetRemainingWorkTrendData()

  
  
  thanks

  Reply

• Joel Joel

  Posted on Apr 11, 2011 (permalink)

  Hello,
  
  Many of the widgets require the user running the dashboard to have read access to the TFS warehouse.  The reason for this is that some of the widgets use data from the TFS warehouse and analysis services only supports windows authentication. 
  
  If you don't need the widgets that require warehouse access you can choose a layout that doesn't display them.  To do this, go into the dashboard settings and choose a layout that ends with "No TFS Warehouse Widgets".
  
  Regards,
  Joel
  the Telerik team

  Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

  Reply


• Ian

  Posted on Apr 14, 2011 (permalink)

  My Admin has provided access to the necessary databases following the document below.
  
  http://msdn.microsoft.com/en-us/library/bb737953.aspx
  
  From the SQL Manager I can access these databases and run queries however,  the dashboard says I either don't have access or the database does not exist. I have verified the DataSource is the correct server and the Catalog is the correct database.
  
  What now?
  
  Thanks!

  Reply

• Ian

  Posted on Apr 14, 2011 (permalink)

  Figured it out...Catalog should NOT be Tfs_Warehouse, it should be Tfs_Analysis. This is confusing because the screen says input the ADOMD Warehouse database.

  Reply

• Greg Greg

  Posted on Apr 18, 2011 (permalink)

  Hi,
  
  I'm glad you figured out.
  
  I apologize for the confusion on the screen. As one of the developers who worked on the Project Dashboard, I was trying to remember the logic around the names we chose for the screen.. And in the end I think it was just an oversight on our part in that you are connecting to the analysis cube in the TFS Data Warehouse.
  
  I've logged a bug to clarify the labels on that screen so that we can avoid the confusion in the future.
  
  Greetings,
  Greg
  the Telerik team

  Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

  Reply

Back to Top

Home / Announcements / Forums / TFS Work Item Manager and Project Dashboard: TFS Project Dashboard > Either the user, <username>, does not have access to the Tfs_Analysis database, or the database does not exist.