We've been trying to deploy to SQL Reports, and have been receiving a error that the IUSR account did not have enough permissions, after reviewing some info it was determine that one of the shared datasources were missing, we created a new one but the problem exist the the bad entry still exist and the reports wont deploy, were hesitant to delete it since there are about 1000 reports that would have to be updated manually, is there a way to create a new datasource and overwrite the existing without having to update every report.
Thanks in advance,
Bob Smith