We just chnaged the sql user password on our RDS. I then chnaged it on the datasource. To my surpise , all datasets created using this datasource are still failing with password issue. I am puzzled. I do not want to drop and recreate the datasets. That is just too much work. I do not even see datasets queries now. Has anyone faced this ssue before?
Any help is appreciated.
As I understand there are two steps in updating the datasource.
You input all required fields and then click the Validate Connection to check if things are working fine.
If all went fine you click the Update data source button to save the changes.
If you did these two then dataset refresh should work fine. Can you double check the datasource using the Validate Connection again to see if it is working? If not can you share what error you are getting ?
hi @kochar - When you update your password, update the data source connection and test the connectivity. If that works, then i believe all data sets should work. As suggested by @Giridhar.Prabhu , please share the error screenshot to understand the issue in detail.