Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Credentials Issue connecting to SQL Server

Hello Everyone,

 

I am trying to connect to a SQL Server Database with a database user. I press the button "Get Data", select the option "SQL Server" and complete the Server and Database fields. I am using the import connectivity mode. When I enter the user and the password I get the following error:

 

Captura.PNG

 

So, my partner tried again but this time from his computer (both using Power BI Desktop, connected from the same network and using the same credentials) and He could connect successfully.

 

Any ideas of why this is happening? 

 

Thank you in advance,

German.

 

Status: Needs Info
Comments
v-haibl-msft
Microsoft Employee

@geermank

 

Are you using the same version (Apr 2017) of Power BI Desktop? Can you connect to the SQL database with SSMS using same credential on your machine?

Maybe you can try to right click the Power BI Desktop shortcut and click "Run as administrator" to see if it works.

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Status changed to: Needs Info