cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

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

1 ACCEPTED SOLUTION

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

View solution in original post

3 REPLIES 3
Community Champion
Community Champion

@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.

View solution in original post

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors