We have a standalone farm Installation of SharePoint 2013. All the below components are on single server say Server1:
SQL Server Reporting Services (SSRS)
I want to integrate cube reports from Server2 which is not added in the farm but it's in the same organizational network. Is above scenario possible just by adding .rdl files and DataSource Connection to a library?
Do I need to add the Server2 as a part of SharePoint farm and install SharePoint foundation on it? Any help would be much appriciated.