Link to home
Create AccountLog in
Avatar of straucha
straucha

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?  
ASKER CERTIFIED SOLUTION
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account