-
report server restore error
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"
-
Found a solution to migration of RS
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|