I'd like to remove the load from reporting from the CAS or primary.
Does it make sense to put a reporting point on a remote box? Remote to SQL? Have SQL reporting installed on SQL, but the RP role on a remote box? How about having a dedicated SQL/Reporting Server just for reporting? Then of course the data has to get there somehow from the site server SQL box. Any ideas? It does sound like not supported though..
