Connecting to remote sql server

[Markzolotoy]

I am trying to get data from a remote server. Because the box I am connecting from is not a domain box Windows Authentication is not working. Hocan I switch to the server authentication?

Thanks

[jr3151006]

Hi,

can anyone help me on how to stablish connection, from external side, when that server is behind a FW forwarding external port in different TCP number?

We have a customer who openned/redirect the TCP '63375' instead '1433'

[parry2k]

i think you should add it with comma in your server name,

xx,xx,xx.xx,<port number>

sql server ip address, port number

[v-yuezhe-msft · Accepted solution]

Hi @Markzolotoy,

You can connect to SQL Server in Power BI Desktop using SQL authentication credentials. Choose Database option in the following screenshot, then enter your username and password to connect to SQL Server.

Thanks,
Lydia Zhang

[rammy]

HI how do i get this screen in power bi desktop

please help me in this

[LuchoTA]

Hi!

Im having the same issue, when i put the SA credentials on that section

This message says that the server wasnt located.

when I try the same thing on the MySql conector, this message appear

Saying it is unable to conect to any specified MySql Host

As far as I know there is credentials por the SQL DB ("sa" user) and also credentials for the server (to access the IP)

The server is in another location so im triying to acces there remotely...

what im I doing wrong?

I also installed some conectors for Mysql that other people recomenden in the forum.

Thank You!

[parry2k]

I belive you can use alternate credentials to connect

[dosc]

Posting this here for people struggling with alternate credentials when connecting to remote SQL Server via VPN from a machine outside of the domain.

You can use the runas /netonly command (this does not work with the Power BI Desktop installation from Microsoft Store). Start Power BI Desktop via cmd with the following command:
runas /netonly /user:[domain]\[user] [path\to\PBIDesktop.exe]

Provide the password and then use current credentials in windows authentication when connecting Power BI Desktop to the SQL Server. You can find a step by step guide here