Azure SQL DB mirroring Error ( set up a managed identity for your SQL Server)

[mohamedabohassn]

i'm trying to conncet  and mirroring  Azure SQL DB but every time i got this error : 

how can i solve this ? 

[v-gchenna-msft]

Hi @mohamedabohassn ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
In case if you have any resolution please do share that same with the community as it can be helpful to others .
Otherwise, will respond back with the more details and we will try to help .

[v-gchenna-msft]

Hi @mohamedabohassn ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
In case if you have any resolution please do share that same with the community as it can be helpful to others .
Otherwise, will respond back with the more details and we will try to help .

[mohamedabohassn]

i now facing another problem it give me this error : PowerBI user with prefix  ---(my db server_name) not found.

[v-gchenna-msft]

Hi @mohamedabohassn ,

Apologies for the delay in reply from our side.
Did you got a resolution for this?

[abohassan]

I want to confirm that enable the system-assigned Managed Identity 

will not introduce any security risks. ?  @AndyDDC @v-gchenna-msft  and how to avoid that

[AndyDDC]

Hi @mohamedabohassn you can enable the system-assigned Managed Identity on the Azure SQL server:

[mohamedabohassn]

thank you andy, for now i don't have access to do it, i  sent a request to my orginaziton and will try it once access granted