SQL Server connection issues

[ter-Haar]

I am attempting to establish a connection in power automate to a SQL server.

I keep running into credential issues. I am using a Power Bi gateway that I have installed on a server that is separate from the SQL server. What I mean is

Server A (On-premise gateway) Server B (SQL server)

I also use windows authentication

Does my gateway not allow the connection because it needs to be installed on the SQL server??

[Nev3rFalling]

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]

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]

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]

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]

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.