Forum Discussion

JohnStraumann's avatar
JohnStraumann
New Member
5 years ago
Solved

Error connecting to Azure Database

Hello all:

 

I am getting an error trying to connect to an Azure SQL Database from Power BI desktop. I set up the firewall rule in Azure, and I know my credentials are correct, but no joy. Can anyone suggest some troubleshooting steps?

 

Thanks in advnace!

 

John.

Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    HI JohnStraumann ,

     

    From your screenshot, it looks like you are entering credentials under WINDOWS section.

    I think you need to add credentials to DATABASE section.

     

    Thanks,

    Pragati

  • PC2790's avatar
    PC2790
    5 years ago

    Hi JohnStraumann ,

     

    Please ensure that your user id is provided access on the database level.

    Also, for  a detailed login error you can try accessing the desired database and table from Sql Server Management Studio.

    It might give you the detailed error.

     

    Thanks

2 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    HI JohnStraumann ,

     

    From your screenshot, it looks like you are entering credentials under WINDOWS section.

    I think you need to add credentials to DATABASE section.

     

    Thanks,

    Pragati

  • PC2790's avatar
    PC2790
    Community Champion
    5 years ago

    Hi JohnStraumann ,

     

    Please ensure that your user id is provided access on the database level.

    Also, for  a detailed login error you can try accessing the desired database and table from Sql Server Management Studio.

    It might give you the detailed error.

     

    Thanks