• Robert Graff (9/11/2013)


    Jack Corbett (9/11/2013)


    I haven't done this in quite awhile, but I will say it sounds like you are just covering over the root of the problem by this workaround.

    Yes, I agree...This is not a permanent solution.

    Jack Corbett (9/11/2013)


    Is there anything else in any of the logs that around the same time that would indicate an inability to communicate with the domain controller? How often does this happen? Does the password for the service account expire?

    I've just found this in ReportServerService_09_06_2013_11_07_44.log

    ERROR: Exception caught while starting service. Error: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. ---> System.Runtime.InteropServices.COMException (0x80090005): Bad Data. (Exception from HRESULT: 0x80090005)

    What do you think? have you seen this before?

    Try to restore the symmetric key.

    http://msdn.microsoft.com/en-us/library/ms157275(v=sql.90).aspx

    --

    SQLBuddy