Menu
On SQL Server 2008 R2 Standard edition whenever I try and update Data Source credentials via the Report Manager I cannot save the changes as it reports the message
"The password is not valid. Please retype the password".
I've looked online and someone thought it could be related to a known issue in Chrome. Unfortunately I've tried Chrome/I.E 11 and Firefox and they all report the same issue. I am choosing the "Credentials stored securely in the report server" option.
Has anyone any idea to work around this?
This could be similar: SSRS Report Manager (2008R2) will not save Windows credential password in data source
601
Open Reporting Services Configuration Manager, and then connect to the instance of SQL Server Reporting Services. Click Microsoft service Identity on the left pane. Change the account and the password in the Account text box and the Password text box, and then click Apply.
For Connect Using, select Credentials stored securely in the report server. Type a user name and password. If the account is a Windows domain user account, specify it in this format: <domain>\<account>, and then select Use as Windows credentials when connecting to the data source.
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)
91
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!!!
22
It is a browser issue. We try it in IE and worked.
20
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
