Test Cube, Test User, connect to it(Azure Analysis Service) in SSMS, right click the cube, browse, click on "Impersonate": And you will see a series of prompts that are specific to a on-premise implementation of AD, so local users, local groups(In this case it's just my local system): How do I select a user from MS Entra through these prompts? If that can't been done is there another easy UI driven way to impersonate a user? Did Microsoft just not extend support for this authentication type to SSMS(at least for Azure Analysis Services)?

Is it possible to have different users accessing my read replica DB? Isn't this in fact a popular use case for a read replica? I want a certain limited set of credentials to have access to my primary read-write DB, and then I want a bunch of other folks to be able to have read-only access to the read replica for reporting, ad-hoc querying, etc. I don't necessarily want the two databases to have the exact same accessors. I created a Microsoft Entra login on the server which hosts my read replica, But here's what I get when I attempt to create the user for the database access. Msg 3906, Level 16, State 2, Line 1 Failed to update database "********" because the database is read-only. Well, of course the database is read-only, it's my read replica. But I'm not trying to write data into the database, merely set the meta-security details for who in my organization is allowed to access the read replica. This can't be done?