Mirrored Azure SQL Database error

[Mathan1787]

While mirroring the  Azure sql database i am getting the below error. why do i need to have an access to Master database in the server.

The database cannot be mirrored to Fabric due to below error: A database operation failed with the following error: 'VIEW SERVER SECURITY STATE permission was denied on object 'server', database 'master'. The user does not have permission to perform this action.' VIEW SERVER SECURITY STATE permission was denied on object 'server', database 'master'. 

[gelouma]

Based on my experience, this error can also occur due to tier issues, if that helps.

[DiegoPLAB]

Hello @v-cboorla-msft,
do you have any news on this fix?
I also have this problem and I wouldn't change permissions on Azure SQL.

[Mathan1787]

if i am copying a table , i dont have to have this elevated permission why only for mirrored option alone. its best to fix this issue. I cannot give elevated permission in production database.

[v-cboorla-msft]

Hi @Mathan1787 

We have updated the internal team regarding the issue. They will provide the fix asap. 

We will update you once we hear back from them.

Appreciate your patience.

Thank you.

[v-cboorla-msft]

Hi @Mathan1787 

Thanks for using Microsoft Fabric Community.
At this time, we are reaching out to the internal team to get some help on this.
We will update you once we hear back from them.

Appreciate your patience.

Thanks

[v-cboorla-msft]

Hi @Mathan1787    

Got an update from the internal team.

At a high level -  the actions required on the logical SQL Server to enable Mirroring require these elevated permissions. We are working on reducing these in future.

For more details please refer : Configure Microsoft Fabric mirrored databases from Azure SQL Database (Preview) 

I hope this information helps. Please do let us know if you have any further questions.

Thanks.