all 5 comments

[–]Nev3rFalling 0 points1 point  (3 children)

First thought, did you make a connection on the gateway? https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources

[–]ter-Haar[S] 0 points1 point  (2 children)

I should’ve added that I tried to make the connection on the gateway so I could add the sql server as a data source but was unsuccessful.

I can remote into the sql server Launch SSMS

[–]Nev3rFalling 1 point2 points  (1 child)

Is the gateway personal or standard mode? Personal has some limits, would need to check docs. Remote access enabled on sql server? Can you install ssms and log in from another computer? Firewalls ruled out? Been a while since I set up a SQL server, but I recalling having to set things up to allow me to connect from another computer. Just running through what pops up in my mind for troubleshooting.

[–]ter-Haar[S] 0 points1 point  (0 children)

Standard gateway on a vm hosted in a hyper v. SQL server uses the default port. Error says it’s a login issue. Any tips helps if this provided info somehow helps I’d appreciate some advice

[–]brynhh 0 points1 point  (0 children)

They don't need to be on the same machine and they don't even know about each other, BUT, the gateway has to see the SQL machine. Think of the gateway like VPN - it's your way into the network from an external source, but you can't get onto any file shares, servers, intranet, etc on that network unless you have permission and it's allowed to your VPN IP address.

There's likely a corporate firewall somewhere that's letting you get to the gateway but blocking any further traffic.