Forum Discussion
SQL Server connection: Failed to update data source credentials
Good day,
I receive the "Failed to update data source credentials" when trying to sign into my SQL Server database.
I have tested the credentials in PowerBI Desktop (and the refresh is working fine on desktop) and SSMS and I am able to access the database.
Because of this, I am not able to enable automatic refreshes which is essential for our Reports.
Any thoughts on how to get around solving this?
with a public IP you could avoid the gateway but the SQL Server instance port must be opened as well, maybe it's been closed.
please note having a SQL Server opened on the public internet is not a best practice.
10 Replies
Is it on-prem or cloud database ?
Hello Cookistador
It is an on-prem database.Did you set up a gateway ?
If yes, is it a personnal or a standard gateway ?
Hi Chibuye_6 ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thanks!!
