Keys lock row not found
I have tried everything suggested in other threads for this and still cannot access my SSRS 2005. I looked in the Keys table in the database and there are no entries. I tried rsconfig, rskeymgmt, etc. and nothing gets a record in there. I assume this is what is needed. Before I throw away SQL 2005 what can I do? Thanks. p.s. On another server with SQL 2008 I have had NO problems.
February 18th, 2011 12:41pm

Hi DavidLife, Did anyone delete the rows? It is basically not safe to open any tables of Reporting Services Catalog databases. It is technically unsupported to work on the Catalog databases directly. After you delete the keys and restart IIS, you need to use the rsconfig utility to specify the connection information to be encrypted. For more information of rsconfig utility, please go to http://msdn.microsoft.com/en-us/library/ms162837.aspx. Hope this helps Thanks, Challen FuChallen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
February 21st, 2011 1:56am

Hi DavidLife, Did anyone delete the rows? It is basically not safe to open any tables of Reporting Services Catalog databases. It is technically unsupported to work on the Catalog databases directly. After you delete the keys and restart IIS, you need to use the rsconfig utility to specify the connection information to be encrypted. For more information of rsconfig utility, please go to http://msdn.microsoft.com/en-us/library/ms162837.aspx. Hope this helps Thanks, Challen FuChallen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
February 21st, 2011 1:56am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics