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
Hi subhra1131101,
Thanks for reaching out to the Microsoft fabric community forum.
1) Ensure that the SQL Server authentication mode aligns with the authentication method being used in Power BI. If SQL Server is set to SQL Authentication, but Power BI is attempting to connect using Windows authentication (or vice versa), the connection may fail. Verify and adjust the authentication settings in SQL Server to match the credentials used in Power BI to avoid authentication issues.
2) Please verify whether the Windows service account you are using to log in has standalone access to SQL Server or not.
3) Ensure the service account is not disabled in SQL Server.
Here is a similar thread to your issue in the Forum: Solved: Unable to update connection credentials. Invalid c... - Microsoft Fabric Community
Feel free to refer to it for any additional insights or key points.
If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS.
Thanks and Regards
The Service Account is active, and Windows authentication is enabled.
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 youHi subhra1131101 ,
Could you please confirm if the issue has been resolved after raising a support case? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.Thank you for your understanding and assistance.
