Problems Automating Reports for SQL Reporting Services 2000
I have a report in SQL RS 2000 that I would like to email every morning. I have many reports this way before. The report never gets kicked off each morning by the RS Scheduler. The event log has an error message that says : "Failed to Decrypt Symmetric Key. Most likely cause is the service username has changed. Source - Schedule and Delivery Processor". The Server has recently been switched over to a different domain and is running under a different system account than the one I set up for RS 2000 during the initail set-up. How can I get the scheduler running under the new account without reinstalling RS?