Forum Discussion

MWilson929's avatar
MWilson929
Frequent Visitor
10 years ago
Solved

Can't connect to Azure Database

Hi All,   I'm trying to connect to an Azure SQL database. I've managed to connect SSMS to the database without too much trouble, but power BI gives me the message;   We encountered an error while...
  • MWilson929's avatar
    MWilson929
    10 years ago

    Solved! I was being a bit dozy and trying to use AD rather than the Server admin account.

MWilson929's avatar
MWilson929
Frequent Visitor
10 years ago

Hi,

 

Error message is as below;

 

We encountered an error while trying to connect

 

Details " "

 

And yes I have configured the firewall. I've sent a "frown" to power BI. Should I be using a particular User and password?

 

As mentioned, SSMS and Visual Studio both connect to the database just fine, but via Active directory authentication.

 

Thanks,

 

Mark

MWilson929's avatar
MWilson929
Frequent Visitor
10 years ago

Solved! I was being a bit dozy and trying to use AD rather than the Server admin account.