PBI connection to SQL

[dskeane]

Trying to connect to SQL server from Power BI using the SQL connection. 

Can confirm that sa login credentials are working from the database source using management studio

Can confirm that remote machine is able to talk with remote server

Error when connecting is....

We couldn't authenticate with the credentials provided. please try again.

Any help on this would be much appreciated. 

[dskeane · Accepted solution]

SA does work from the database source, what i found was connecting to another user name with permissions to access tables did work. Not sure why SA wouldnt though? 

Either way I now have access to my database connecting from Power BI. 

Thanks for the suggestions.

[Anonymous]

Hi @dskeane ,

This maybe a permission/authentication error. When you ever connect to  your data source in an unauthorized account, the corresponding credential would be created.

Did you select Database type and use your sa account to connect to SQL? 

Actually I have used the following sql to create a new login——Name: test  Password : pass for database [master]:

CREATE LOGIN test WITH PASSWORD = 'pass', DEFAULT_DATABASE = [master] , DEFAULT_LANGUAGE = us_english, CHECK_POLICY= OFF;

Then I could use Database Authentication to connect successfully in both SQL Server database and Power BI Desktop. You may have a try.

A similar thread:

Solved: We couldn't authenticate with the credentials prov... - Microsoft Power BI Community

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.