Forum Discussion
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 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
Solved! I was being a bit dozy and trying to use AD rather than the Server admin account.
3 Replies
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.
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
Solved! I was being a bit dozy and trying to use AD rather than the Server admin account.
