just an easy question/need this morning. I'm looking for informations pointing out that a data source shouldn't be too far away from SSRS. I have a request to create additional data sources that will point to several remote locations. I have a gut feeling that this isn't best practice at all.
Hmm...frankly speaking I do not know what to answer precisely ;) But it is definitely not the best option unless it is the only one you have. It could mean if there are several remote locations with reports of large data sets (simultaneous run), you could be having lots of performance, timeout, Logon issues etc. It can even make your server slow for the local DBs. So this becomes sort of Capacity Planning. If you have an ultra fast network, multiple network routes, multiple network cards, a beefy server, then you may get away with this ;)
But one should ask why there is a need for that? Less hardware resources OR someone put an idea to have a centralized Reporting Server for all remote sites for centralized management?
answered Jul 19, 2012 at 11:32 AM