Printable View
I moved a sql 2005 report server db from one server to a newer box. I restored the db but I get the following error message
Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
THe ms help was of little use, anyone seen this before
You need run reporting services configuration to point RS to new sql server.
That worked, now I get
Report Server Windows Service (MSSQLSERVER) has not been granted access to the catalog content.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Once again when you go to the link for this error, you get "No information available for this error"
I have run into this issue a couple of times and have forgotten how to solve, so I wrote up a page on how to fix, including help for downgrading SQL editions from enterprise.
http://www.sqlwebpedia.com/content/h...ces-new-server
-Chuck Lathrope