SSRS Update Data Sources always reports "The password is not valid. Please retype the password."
Ultimately it was a browser/javascript issue I think..
There was nothing I could do to force the password to be saved using the form as it is designed.
The only work around I found was I had to switch focus between the three radio button options ("Credentials stored securely in the report", "windows integrated security "and "Credentials Not required") and then test the connection (it fails). Then I had to switch back to "Credentials stored securley in the report" and it worked.
Edit, this workaround worked on Firefox and Chrome (I haven't tried I.E)
and I had this problem too.
initially I thought I had my MYCOMPANY\reports
account password wrong, and I even tested the whole thing with a different account, only to find out the same problem was happening -
"The password is not valid. Please retype the password".
then I used my own account with all its super powers and still the same error message, which then concluded that it was not related to AD or firewall.
what I did is, changed the settings to use Windows Integrated Security
, tried it and applied even if it didn't work, then switched to some other option and again applied and saved.
ultimately I came back to Credentials stored securely in the report server
, put the account and password, and it worked.
half a day wasted, but it worked.
I don't want anyone wasting their days with this, I am sure you can have a better option for that, given the opportunity.
hence the post here including the picture and all. have a good day!!!
It is a browser issue. We try it in IE and worked.