Forum Discussion

Markzolotoy's avatar
Markzolotoy
Impactful Individual
9 years ago
Solved

Connecting to remote sql server

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
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

jr3151006's avatar
jr3151006
Helper IV
9 years ago

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's avatar
parry2k
Super User
9 years ago

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

 

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

 

sql server ip address, port number