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.