TFS_Wareshouse and TFS_analysis database creations??

Question

During upgrading TFS 2008 to 2010, I opt out reporting section.Now I want to integrated migrated team collection and project with reporting services. i have installed SQL reporting 2008 services on app tier.

Now in Team foundation admin console, after selecting reporting tree, Clicked edit.  It's asking warehouse and analysis dbs. Truly no db created during migration. Do I have to create those dbs manually?? If so, could you please share what are the minimum permission for those dbs for successfully completing this integration.

Do we need to create TFS_Wareshouse and  TFS_analysis data bases manually.??

If So, what are the permission need if I have to created manually.

Answer 1

Please check below link..

http://msdn.microsoft.com/en-us/library/ff400237.aspx

Best Regards,
Omantha Prasd

---

System Support Engineer i-Context Content Convergence (Pvt) Ltd