Password Change for SQL & RS

Question

Hello,

The environment is:

• 1 SQL Server
• 1 Reporting Server
• 1 Primary Server (MS)
• 1 Management Server
• 2 Software Update Servers
• 1 Cloud Management Gateway
• 12 Distribution Servers

The password of the svc_ConfigMgr_SQL & svc_ConfigMgr_SQLRep have been changed.

and I have an access issue to the reports:

An error has occurred during report processing. (rsProcessingAborted)
Cannot impersonate user for data source 'SMSDB'. (rsErrorImpersonatingUser)
Log on failed. Ensure the user name and password are correct. (rsLogonFailed)
The user name or password is incorrect

I think I missed one place to update the password but could not find which one.
I changed:

• SQL Server Reporting Services (MSSQLSERVER)
• Reporting Services Configuration Manager:
  a. service account
  
  b. database - nothing changed !!
  
  but I was not able to change it... I do not see the "Service account" option in the drop down list
  

Also I changed the password on the Datasource and the "Test connection" was successful.

I clicked "Apply" but I never see any result "applied" ... I do not see any "OK" or "Saved" to confirm the new password is picked...

Any idea?

Thanks,
Dom

Answer 1

for clarity, you don't change the data source password from Ssrs website but from within the configmgr console.

Answer 2

Hi @Duchemin, Dominique
About changing the user account or password used for database connections, if you connect using a service account that uses Windows Integrated Security as the credential type, the password is not stored, eliminating the need to update the connection information.
For more details, you can refer to this link: configure-a-report-server-database-connection-ssrs-configuration-manager.
Best regards,
Aniya

Answer 3

Hello,

I think it is the one I missed. I checked Administration > Overview > Site Configuration > Servers and Site System Roles > Reporting Service point
I saw the account but no field for the password? as it is just a change password should I remove the current account and then readd it might ask for a password at that time?

I checked also:
https://learn.microsoft.com/en-us/troubleshoot/sql/reporting-services/best-practices-change-service-account?source=recommendations

Resolution:
I removed the account then add it back with the new password.
Restart services on the Primary Server

• SMS_EXECUTIVE
• SMS_NOTIFICATION_SERVER
• SMS_SITE_COMPONENT_MANAGER
• SMS_SITE_VSS_WRITER

and now everything is working...

Thanks,
Dom