migrate reports database without encrytion key

[niall5098]

HI THERE, I have an issue whereby the expirataion period has passed on an evaluation copy of sql server. a developer created reports and never backed up the encryption key. I was wondring if it was possible to re-attach the reports and reportservertemdb to a new instance and reconfigure RS services and hope that the reports are visble in the new reports URL.

Is it possible?

 

[ramam1]

I don't know. Doesn't the developer have the RDL files (or maybe even the entire project files for the report)? Unless you don't want to deal with recreating subscriptions and typing in user/passwords for reports I think you only need the RDLs.

 

[mrdenny]

You should be able to just reinstall over the old Eval edition doing a SKU Upgrade from Eval to Standard or Enterprise edition.

Failing that they will need to take the RDL files an upload them to the new server.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
MCM (SQL 2008)
MVP

My Blog

 

[niall5098]

upgrading the sofware will require a new licence which will cost the client more money.

the developer has moved on and is now uncontactable so the only information i have is the database, i can do a search for the RDL files in the mean time.

thanks

 

[mrdenny]

If the client is using the server for development or production use then they need a license anyway. You can't just keep reinstalling the Eval edition over and over.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
MCM (SQL 2008)
MVP

My Blog