Forum Discussion

wenners68's avatar
wenners68
Icon for Helper II rankHelper II
9 years ago

Can't connect to Azure SQL Database

I'm trying to access my SQL data on Azure and get this message each time. This worked before with the same credentials, but now stopped literally overnight. I can access the data through SSMS. Any id...
miltenburger's avatar
miltenburger
Icon for Helper V rankHelper V
9 years ago

wenners68

 

I had the same problem yesterday,

What the problem was:

 

My database (also sql) refreshed on mondaymorning 09:00, when the database refreshed, i lost connection with this database.

So they needed to give me permission to access the database, it seems that they have to do it every time the database refreshes.

 

Maybe this helps you out

  • wenners68's avatar
    wenners68
    Icon for Helper II rankHelper II
    9 years ago

    We spoke to Microsoft, who suggested that we run Power BI as an administrator and connect to Azure SQL as an administrator while they look into this issue.