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 connect I get the error message "We couldn't authenticate with the credentials provided. Please try again." After logging into the VPN, I can ping the remote SQL server, but my account is not authorized for remote login to the machine. Is remote login required in order for my account to connect to the SQL database from Power BI?

 

Thanks. 

 

Need Help
  • rocky09's avatar
    rocky09
    8 years ago

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

9 Replies

  • rocky09's avatar
    rocky09
    Solution Sage
    8 years ago

    try this:

     

    Get Data --> Blank Query-->

     

    = Sql.Database("xx.xx.xxx.xx", "SchemaName", [Query="Query here"])

     

    First time, it will ask for credentials, provide SQL Credentials. :).

     

    I hope, this will help.

    • jdormer's avatar
      jdormer
      Helper I
      8 years ago

      Thanks, rocky09. Currently, I am going to Get Data -> SQL Server, entering the Server and DB, then selecting Windows Credentials and entering Windows credentials that have read access on the database. Can the connection be made with Windows credentials?

      • rocky09's avatar
        rocky09
        Solution Sage
        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
    4 years ago

    I am seeing the same thing. 

     

    I can connect without any issue using Windows Authentication from SSMS.  

     

    I cannot connect with the same credentials from Power BI.

Related content