No, the name of the database stayed the same (BESReporting). When I go to the Database tab I noticed that the database was disabled. When I re-enabled it all the information is now there.
After migrating my clients to a new server with SQL2008 I’m am having this same issue. I created some reports and they worked fine for a couple of days, but it seems that they broke after a server reboot. I restored the database to the dy before the reboot, and once more the reports worked for a couple of days and then I started receiving the NoSuchSiteID message this time the server wasn’t rebooted.
I came from a Server 2003x86 SQL 2005 running BES 7.2.1.357 to Server2003x64 SQL2008 running BES 7.2.5.22.
The migration was successfull, only web reports is giving me problems.
Support has helped me with my issue. Apparently when I imported some tables from my old server, the filters where still referencing to my old database. Supprt showed me how to enable logging on BES Web Reports to find out what reports were doing this. After recreating the filters (I had already attempted to recreate reports) the issue seems to be resolved.