How to create/ use report server in TFS?

Hi,

I am trying to extract reports from the TFS database but have no idea exactly on how to do it. I am trying to download some predefined reports from a web report server we have and open it in Report Builder. However, it is requiring a Report Server, which I don't know what to inform or how to locate such server. I though that would be the same as in my url of the web report server, but it's not working. The Report Builder opens a pop up Connect to Report Server with the message: "This report requires a report server". Type or select the report server you want to use. However, I don't have any and don't know how to find it.

When trying to run the report in Report Builder, I get the following message: "An error occurred during local report processing. The item '/TfsReportDS'  cannot be found". Then I found the link below:
http://social.msdn.microsoft.com/forums/en-US/tfsreporting/thread/53eef046-cb81-4cb4-b3a5-a8c8f08d56fa

I followed the solution, but I am stuck on the "Connect to a database". I tried to inform TFSWarehouse, typing this directly, since it didn't appear and the message was that "A connection cannot be made. Ensure the server is running".

Any help will be greatly appreciated.
DistillingExpertsAsked:
Who is Participating?
 
Mez4343Connect With a Mentor Commented:
yes that is the Report server that you need permissions on.
http://<machine>/Reports

Report Builder remotely connects to the SSRS database, so you need permissions.
0
 
Mez4343Commented:
The ReportServer is the database instance where you have installed SSRS Reporting. This is a seperate install and not installed by default. To make sure you have it installed:

1) right-click Computer and select Manage
2) Select Services and scroll down and verify you have SQL Server Reporting Services running

If you dont have it, you need to get the SQL Server 2005/2008 CD or Setup program . See this for install considerations. http://msdn.microsoft.com/en-us/library/ms143736.aspx

Once installed, try to access it from your browser as->  http://machinename/Reports/Pages/Folder.aspx

You can then upload RDL files to your report server from the Browser or open Report Builder connecting to the same URL and run/modify them from there.
0
 
DistillingExpertsAuthor Commented:
Thank you for your answer. Before I go to the install process, I think we already have ReportServer installed, but this is in one of our servers, otherwise I think I wouldn't be able to see the TFS predefined reports we already have. Is there any way to find that out? Thank you.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
Mez4343Commented:
Yes try to open Report Mananger from your browser where machinename is the name and port of the server.

http://machinename/Reports/Pages/Folder.aspx

0
 
DistillingExpertsAuthor Commented:
I tried to do that but I have no permission. Should I assume that the Report Server name is
http://<machine>/Reports, given the page we have setup here is http://<page>/Reports/Pages/Folder.aspx? If it is so, it doesn't work in the Report Builder, why?
0
 
DistillingExpertsAuthor Commented:
Sorry.. correction
I tried to do that but I have no permission. Should I assume that the Report Server name is
http://<machine>/Reports, given the page we have setup here is http://<machine>/Reports/Pages/Folder.aspx? If it is so, it doesn't work in the Report Builder, why?
0
 
DistillingExpertsAuthor Commented:
Well, that turned out the Report Server wasn't http://<machine>/Reports. I asked the DBA to take a look and found out in Reporting Services Configuration Manager, under "Report Server Database Name" that the report was name as "X". So I had to inform http://<machine>/X and it worked. Aside from that, it was given admin permission for me to access the TFS database. However, I will give you the points, since you were the only one helping.

Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.