Forum Discussion

jdormer's avatar
jdormer
Helper I
8 years ago
Solved

SQL - "We couldn't authenticate with the credentials provided"

Good morning,    I am having difficulty connecting from my local Power BI Desktop to a SQL server in a client's environment. My account has read access on the database, however, when I try to conne...
Need Help
  • rocky09's avatar
    rocky09
    8 years ago

    You need to provide Server credentials not windows. Use Other Tab.

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi jdormer,

 

Do you have the SSMS in your computer? You can log into the SSAS with SSMS. If you can, your credential should be good.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Did you get the error message like this? This means your credential is invalid. Please contact the DBA or check it yourself.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 Did you enable the TCP/IP connection?

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

jdormer's avatar
jdormer
Helper I
8 years ago

Thanks, v-jiascu-msft and rocky09 for your response.

 

Used SQL credentials and was able to connect. 

 

 

Related content