Monday, March 12, 2012

Move RS from old server to new server

I need some assistance in moving RS databases from an old server that has SQL
Server 2000 to a new machine. I was able to move the ReportServer and
ReportServerTempDB to the new machine and seems to see all the reports, but
I'm getting an error when trying to run them. "An error has occurred during
report processing. (rsProcessingAborted). Bad Data".
I had tried following http://support.microsoft.com/default.aspx?scid=842425
but no luck.
Here's the steps that I had done.
1) Detach Both databases from old server that host Reporting Services.
(ReportServer and ReportServerTempDB)
2) Attached them to new server.
3) Did "Delete from Keys where client > -1" on the new server
4) Did rsactivate to initialize.
5) Did RSConfig (Not sure if this needs to be done on source or
destination) I did this on the new server.
Only thing i left out is RSKeyMgmt.exe since that says that it will extract
the key from my source. Not sure if this will mess up the source server
since that is still be use until I can move everything to the new server.
So can someone that has move Reporting Services to a new server please help
me out?
P.S. The reporting services server does not host any of our ERP databases.
It is on a different server and the reports will grab those using datasources.
Thanks in advance.To answer your question about extracting the Key, the reason it asks you if
you want to extract the key is because this is a security issue if you leave
the file out in an un-secure location. You RS installation will continue
just fine after extracting the key; think of this as more of a BACKUP then as
an EXTRACTION.
"chang" wrote:
> I need some assistance in moving RS databases from an old server that has SQL
> Server 2000 to a new machine. I was able to move the ReportServer and
> ReportServerTempDB to the new machine and seems to see all the reports, but
> I'm getting an error when trying to run them. "An error has occurred during
> report processing. (rsProcessingAborted). Bad Data".
> I had tried following http://support.microsoft.com/default.aspx?scid=842425
> but no luck.
> Here's the steps that I had done.
> 1) Detach Both databases from old server that host Reporting Services.
> (ReportServer and ReportServerTempDB)
> 2) Attached them to new server.
> 3) Did "Delete from Keys where client > -1" on the new server
> 4) Did rsactivate to initialize.
> 5) Did RSConfig (Not sure if this needs to be done on source or
> destination) I did this on the new server.
> Only thing i left out is RSKeyMgmt.exe since that says that it will extract
> the key from my source. Not sure if this will mess up the source server
> since that is still be use until I can move everything to the new server.
> So can someone that has move Reporting Services to a new server please help
> me out?
> P.S. The reporting services server does not host any of our ERP databases.
> It is on a different server and the reports will grab those using datasources.
> Thanks in advance.

No comments:

Post a Comment