asked on
Problems Automating Reports for SQL Reporting Services 2000
Hi experts,
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?
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?
Microsoft SQL Server
Last Comment
EugeneZ
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.