Forum Discussion
On-premise SQL connection doesn't work on Gateway from PBI Service (does it need encryption local?)
Anonymous My first thought here is always that something in the connection string is wrong. Looking up the tail end of the error I would re-check that. Possible simliarities correlate with this post about that error in an application.
https://www.sqlservercentral.com/Forums/Topic1816362-2799-1.aspx
Anonymous My first thought here is always that something in the connection string is wrong. Looking up the tail end of the error I would re-check that. Possible simliarities correlate with this post about that error in an application.
https://www.sqlservercentral.com/Forums/Topic1816362-2799-1.aspx
Hi Anonymous,
Thanks for the reply. The connection string is just the local network IP adress e.g. 10.xxx.xx.xx and the port number so:
10.xx.xxx.xx:62123 - which is exactly the same as I use to connect the desktop to the same sql server.
Could it be that this issue is port-related? I also tried without specifying the port number, stil didn't work.
Thanks
I have done some testing using a similar environment and it seems that the connection from gateway fails when I try specifying the port number behind the ip adress. It works on general 1434 but not when the port is specified. Anyone else encountered this issue or managed to solve this in a similar context?
Thanks!
It turns out that when connecting to a specific port in the Power BI gateway from PBI Service you need to specify the port number as ip , port e.g. 10.0.0.100,1234 and not :1234 as I do in PBI Desktop. This would be great to have in the documentation or at least have it harmonized between the two. Thanks for putting me on the right track Anonymous!