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

7 Replies

  • parry2k's avatar
    parry2k
    Super User
    9 years ago

    I belive you can use alternate credentials to connect

     

    • dosc's avatar
      dosc
      Frequent Visitor
      3 years ago

      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

  • Anonymous's avatar
    Anonymous
    Not applicable
    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

    • LuchoTA's avatar
      LuchoTA
      New Member
      5 years ago

      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!

    • rammy's avatar
      rammy
      Helper I
      4 years ago

      HI how do i get this screen in power bi desktop

       

      please help me in this

       

  • 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