Thursday, February 23, 2012 7:22 AM
Here is the mystery,
According to the TFS Admin Console wizard, Analysis services are setup and WORKING, e.g. the Test Connection works
However in SQL we have the below ?
Where is it hiding ?
Do i need to run X to create it even though the connection test says OK ?
Extra bonus points if you can explain the TFS_Warehouse and TFSWarehouse DBs (the former being the one referenced in reports), something to do with TFS 2008 upgrade ?
(OK, IE would not let me submit, submit triggers cancel, Firefox would not let me add picture)
Thursday, February 23, 2012 10:10 AM
Analysis services database is running under the context of Analysis Services and that is why you do not see it in you list of the databases.
If you make a connection with the SQL Server Management Studio and use the analysis services Server Type you'll see your Tfs_Analysis cube/database
As for the list of your databases TFSWarehouse is the old warehouse database.
Check also here for some more details:
http://social.msdn.microsoft.com/Forums/en-US/tfsreporting/thread/6b369e57-80b5-43cf-9bfc-da41f6045fbe (Tfs_warehouse and TFSWarehouse DB present after upgrading)
Please remember to mark the replies as answers if they help. --- Success, Damir
- Marked As Answer by Greg B Roberts Thursday, February 23, 2012 11:36 AM