title: SQL Server 2008 R2 Distributor on Subscriber for Reporting DB?
body: <p>I have to setup a database for reporting, and I chose transactional replication for that because it seems the easiest way (setup has to be easy, i will have to explain to customers how to do that). Now for that i do need a distributor database, and i found information that it should not be on the publisher. As there will only be one subscriber, and the performance of the publisher matters alot and the performance of the subscriber does not, I was thinking of setting up the distributor on the subscriber. Does that make sense and is that even possible?</p>