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

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