One of our developers left the company and we had to reactivate his Windows Account so the Reports he created in SQL Reporting Services wouldn't fail; is there a way to programmatically change ownership of Reports; it would be very cumbersome to have to republish every one of them manually. Thanks.
No 100% sure, but i think one of the fields in the Catalog table of the Report Server database holds the owner info. You could possibly write some SQL to update this? Hope that helps!