Renaming The Reporting Services TempDB Database

Strange that I’ve never had/wanted to do this before, helping someone do it today and renaming it causes everything to break. The main ReportDB (regardless of what you named it) has hard references to the location to the ReportingTempDB (whatever it was called when you did the install). I found this post from quite a while back and it’s still useful, but on SQL 2012 there is a function and two views that also need to be changed in addition to searching through all the stored procedures.