A data connection to a SQL DB is created and published to a data connection library in SharePoint 2010. When Report builder or SSRS consume this connection, does the actual network connection happen between the SP server and the DB or the client machine
and the DB? And is this different based on whether you use SSRS or Report Builder?
The reason for the question is that the firewall is open between the SP farm and the DB but NOT between the client machine and the DB and I'm trying to figure out if this will be a problem or not.
Additional clarifications that may be helpful. SSRS (SQL 2008 R2) is in SharePoint integrated mode and we are specifically talking about rsds files.
View Complete Post