October 25, 2024 at 4:10 pm
This is something that happened while investigating a problem - so not impacting me any more - but I wonder what I'm missing.
When trying to change the Service Account in the Reporting Services Configuration Manager from built-in to a domain account, it fails to connect to the database with the error:
A connection could not be established with the information provided. Hit OK to change your connection settings.
A connection was successfully established with the server, but then an error occurred during the login process. (Provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)
I'm presuming this is related to the encrypted connection property of SQL 2019 which we're not using (when setting up the databases during installation, there's a checkbox) but at the point of changing the service account, there's no equivalent checkbox. Cancelling out of the process resulted in the service failing to start until I reverted it to the built-in account.
So what is the right way to change the service account? I tried updating it in services after the failure but that didn't solve the problem.
Thanks.
October 26, 2024 at 5:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply