report server restore error

[timc]

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

[rmiao]

You need run reporting services configuration to point RS to new sql server.

[timc]

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"

[sqlguychuck]

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