Can't connect to Azure Database

[MWilson929]

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 trying to connect

Details " "

I've looked at several other posts and documentation, but it can't see anything amiss;

1. Server name is as listed on Azure portal

2. Server is setup to accept Azure services. The firewall is configured to accept the outgoing internet IP

I'm at a loss. Is there anything I've missed?

Many Thanks,

Mark

[ankitpatira]

@MWilson929 what is the error you're getting. is it saying cannot open server 'yourservername' ? In Azure Portal have added your IP address ? You need to go to Azure Portal, your sql server, firewall  settings pane and enter your IP address and save.

[MWilson929]

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 · Accepted solution]

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