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,

 

There could be many causes. Do you have SSMS (SQL Server Management Studio) in your computer? You can try to connect to SQL Server in SSMS first. Then you can exclude some possibilities. 

 

Best Regards!

Dale

  • jdormer's avatar
    jdormer
    Helper I
    8 years ago

    Hi v-jiascu-msft,

     

    I believe the server has SSMS, but I do not have access to remotely connect to the server. 

     

    Based on the response from rocky09, it sounds like only SQL credentials will work?

    • 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

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hello,

         

        Does this mean that I cannot update a report that was created by someone else?

         

        My colleague created a report and sent it to me. I saved it as something else and now I cannot refresh the report because it is asking for credentials. When I try to sign in as me, it gives me an running script error and it will not refresh.

         

        Any suggestions?

         

        Thanks,

        Andrea

Related content