We are looking at creating a reporting server for SQL. We want to offload this functionality, so that clients can run reports without risk of taxing the core SQL servers, so the ideal would be a read only copy running on a dedicated server, mirrored from the live, that can be connected to with things like crystal reports to query.
How do we go about this? What are the licensing requirements? And what are the data frequency options?