Forum Discussion

Miruthan's avatar
Miruthan
Icon for Advocate V rankAdvocate V
8 years ago

Windows - Alternate credentials not working in Import\Direct query

Hi,

 

I am trying to use Alternate credentials of Window to connect SQL Database, encountering error of couldn't authenticate with credentials.  I am able to connct same instance from SSMS without any issue.

 

I tried with live and import onnection. no luck!.

 

Anything special needs to take care?  Please share your thought.

Need Help
Tips and Tricks
Tutorial Requests

3 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi Miruthan,

     

    What about using default windows authentication or database authentication? And please check if your sql server instance allows remote connection.

     

    Regards,

    Jimmy Tao

    • Miruthan's avatar
      Miruthan
      Icon for Advocate V rankAdvocate V
      8 years ago

      v-yuta-msftI am able to RDP the SQL server instance. Database authentication and Default window authetication dont have access on Database. Only alternate credentials.

  • ozhug's avatar
    ozhug
    Icon for Advocate II rankAdvocate II
    8 years ago

     

    I fixed this running PowerBI as an Administrator.

     

    Right click on Power BI icon , (right click on the icon again if it was in your task bar) and select "Run as administrator"