I have over 200 sites and I am using SSRS reporting. Each site has 20 reports. When the credentials change this is an obvious headache. Is there a powershell script to update the username/password of the reports or do you have to do this manually? The reports are stored in a document library in Sharepoint.