I know what has caused my issue, it but don't know the solution. I'll explain my issue and hope someone can point me to a solution.
I am testing an upgrade of reporting services 2000 to 2005. I installed 2005 on a new dev server (both instances default instances) and told it not to configure. I restored my databases from the production server. BUT, when I did the upgrade I ran into serious issues with an installation bug. My databases were named NFSRSReportServer and NFSRSReportServerTempDB
. The installation wouldn't upgrade these (error in script) because the database names end in the default names but it's not the entire default name for the databases (I'm not kidding
). SO I had to rename the databases. New names are NFSRS2005 and NFSRS2005TempDB.
My understanding is that if I didn't rename them I would have errors on every SP I installed and would have to edit scripts to make it see the real names.
After restoring the databases by a different name, going through the upgrade, installing the encryption key, I am having problems with subscriptions. When I try to edit subscriptions it fails (the subscriptions are also not working and failing with the same error when they try to run in agent) with the error:
System.Data.SqlClient.SqlException: Invalid object name 'NFSRSReportServerTempDB
It's using my old database name (highlighted above
), not the new one - NFSRS2005TempDBCan someone tell me how to tell RS what the correct name for ReportServerTEMPDB is?
Based on responses from post
It appears the data is stored in the rsreportserver.config - but encrypted.