Yes. We can have more than one Prognosis Reporting server push data into SQL Server concurrently.
Each SSRS despite what SQL Server is used to deploy it can have something called a Data Source that can be configured to point to any SQL Server sitting in the organization's environment.
