I have a TFS server that is installed in one of our production servers. Now I need to create a front end to provide access to all the out of box SSRS reports that are available for TFS to one of our clients. Since this is a production DB server I do not want to expose this to the client or outside world. What is the best possible option to achieve what I am looking for?
I am thinking of using another server within the same domain to install just SSRS component and deploy all the TFS reports to this server. I want to setup a URL to this report server and expose it to the client so that they can access all the out of box TFS reports as well as some that we have custom built for their use.
Please provide your advise on whether or not this is a reasonable solution, and/or if there are better choices. Your inputs are grately appreciated.
SQLCurious