I've configured my TFS 2010 for use with my VS2010 clients. I have all the updates and patches. Under the Application Tier, Reporting tab, I do the following:
Select "use" reporting. I drop down and select my stand alone SQL 2008 Server r2 instance. I tupe in TFS_Warehouse under the database tab and select test. The test states it sdoesn't exist but will be created and populated for use with TFS.
I then move to the Analysis tab. I then drop the tab down to my SQL server. Under database, I enter TFS_Anaylsis. for my username I enter "sa". As a note the TFS_Analysis doesn't exist on my SQL server.
Next, I continue to Reports. I select my SQL server and hit the populate URLs, They populate,
The reports look as to use HTTP. My SQL server doesn't have IIS installed. If I select the TFS server instead of my SQL server and hit populate, I get the foloowing SQL server Reporting services could not be found error. So I revert back to the SQL server and repopulate the URLs.
When I hit "ok", I get the error: Could not load file or assembly"micorosoft.analysisservices.version 10.0.0.0,culture=neutral,publickeytoken=89845dcd8080cc91'or oe of its dependencies. The system could not find the file specified.
I have reinstalled several times. I am able to publich code to the server.
Can you assist.