Forum Discussion
Enterprise gateway error suddenly to SQL connection
Hi guys, I had suddenly received a strange error on my enterprise gateway. This is the scenario: we have a dataset that was working correctly (till yesterday) with scheduled refresh from multip...
v-ljerr-msft
Microsoft Employee
Microsoft EmployeeHi Anonymous,
I tried to connect through PBI Desktop and I can query he DB,
Are the SQL DB and PBI Desktop on the same server/computer?
Could you try using “IP address, port” or “tcp:computername” as server name to connect to SQL Server and check if it is successful. For more detailed troubleshooting steps, please review the following blog.
http://social.technet.microsoft.com/wiki/contents/articles/2102.how-to-troubleshoot-connecting-to-th...
In addition, here is a similar thread in which a workaround was mentioned. Could you go to check if it helps in your scenario? :smileyhappy:
Regards