I’ve helped with this issue a couple of times now so thought it would be ideal to blog. Basically when running a remote SQL instance,
The Report Builder click-once application does not exist on the report server.
I recently had this issue whilst trying to create a report in SCCM 2012. It seems this issue has manifested post SP1 install. 12/05/2014 Update