Forum Discussion
Unable to update connection credentials. Logging into Sql server failed.
Hi subhra1131101,
As mentioned by mopowerbi If feasible, consider creating a new connection and reconfiguring the existing reports to utilize it.
If it is not feasible, Please consider reaching out to Microsoft Support. You can provide them with all the troubleshooting steps you've already taken, which will help them understand the issue better and provide a resolution. They might be able to identify something specific about your admin account setup or provide a solution that isn't immediately obvious.
Below is the link to create Microsoft Support ticket:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
Thank you
I had a similiar issue. I was only able to address it by creating a new connection.
This is the error that I am getting :
Unable to update connection credentials.
Logging into Sql server failed. Possible reasons for this error include an invalid authentication mode, a missing login in Sql server, a login from an untrusted domain or a problem contacting the domain controller for the authentication request.
Details:
abc_Gateway: Received error payload from gateway service with ID 332793: SqlException encountered while accessing the target data source.
xyz_Gateway: Received error payload from gateway service with ID 332794: SqlException encountered while accessing the target data source.
As a sanity check, I put in the wrong password, and this was the error that I got :
Unable to update connection credentials.
The on-premises data gateway's service account failed to impersonate the user.