How to create/ use report server in TFS?


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:

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.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.

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.
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.
Yes try to open Report Mananger from your browser where machinename is the name and port of the server.


Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

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?
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?
yes that is the Report server that you need permissions on.

Report Builder remotely connects to the SSRS database, so you need permissions.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.