Forum Discussion
Solved
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...
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.
Hello R1k91
We have a public IP set up with our ISP to expose the database. I am able to access it anywhere outside my private network and, it was working just fine until a few days ago.
I will setup the gateway anyway and try to connect like that.
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.