Comments posted to this topic are about the item Fixing an SSRS Password Error while Changing Credentials
Hall of Fame
This is an interesting article. Thank you for sharing!
What I'd like to know however is what causes this behavior. Seems like a bug, no? What version did you test this on? Were you able to reproduce this on another server/version, etc...?
Yes, looks like bug else it should not prompting me for invalid password when i haven't key-in the password. I encounter this few times, Build was 10.0.2531
BilalAyub - Tuesday, May 16, 2017 2:22 AM
Sorry build was 10.0.6535
This happens to me even when the credentials/authentication method aren't changed, i.e. I'm simply making a change to the connection string to point to a different server, etc. I have dealt with this issue quite a bit and the following workaround works for me:
1) Make whatever changes are necessary, then select auth method "Windows Integrated Security" or "Credentials Not Required" and click Save.
2) After changes are saved successfully, go back and change auth method to "Credentials stored securely in the report server", enter credentials, and then click save. It should be successful this time.
I always thought that making changes to the SSRS databases was not recommended.
Nestor Jarquin - Tuesday, May 16, 2017 9:36 AM
It's not recommended and it's not supported. The only supported methods would be using Report Manager, the RS utility, Powershell or other apps that would access objects in the database through the SOAP API.
only change Windows integral security
click test connection
on test passed
change credential again with new user and password and clic again test conection
on test passe
Viewing 8 posts - 1 through 7 (of 7 total)