Forum Discussion
Workspace Identity with Azure SQL Databases
Zanqueta Thanks for the reply, appreciate you taking the time to do that.
I have managed to get the mirroring working. Having the Workspace Identity as part of a group, with the group created as a user on the db with relevant permissions
CREATE USER [Workspace Identity Name] FOR LOGIN [workspace identity Name]; GRANT SELECT, ALTER ANY EXTERNAL MIRROR, VIEW DATABASE PERFORMANCE STATE, VIEW DATABASE SECURITY STATE TO [Workspace Identity Name];
This failed for me initially, I expect there may have been a delay getting it all to work.
I set up a connection using the workspace identity and assigned that to a report to see if it would refresh and it did. I then retried assigning the connection to a mirror and it worked as well.
Zanqueta Thanks for the reply, appreciate you taking the time to do that.
I have managed to get the mirroring working. Having the Workspace Identity as part of a group, with the group created as a user on the db with relevant permissions
CREATE USER [Workspace Identity Name] FOR LOGIN [workspace identity Name]; GRANT SELECT, ALTER ANY EXTERNAL MIRROR, VIEW DATABASE PERFORMANCE STATE, VIEW DATABASE SECURITY STATE TO [Workspace Identity Name];
This failed for me initially, I expect there may have been a delay getting it all to work.
I set up a connection using the workspace identity and assigned that to a report to see if it would refresh and it did. I then retried assigning the connection to a mirror and it worked as well.
