Currently we have CM 2007 deployed, with SQL running on SQL 2008 R2 Our Central site is configured to use Server1 as its SQL Reporting Point. When we set up our Regional child site to use Server1 for its SQL Reporting Point, things got ugly and the child site complained about the same Site Server (Server1) being re-used.
It was set up to use the same Reporting DB, and site, could this be the cause of the issue? If it was set it up to use its own Reporting DB, and URL on Server1, would it co-exist without causing any SCCM issues? Thanks Andrew

