Home Dashboard Directory Help

SSMS: SQL 2012 High Availability Group Error: "Cannot Show Requested Dialog (sqlmgt) by Jeff_Block


 as Not Reproducible Help for as Not Reproducible

Sign in
to vote
Type: Bug
ID: 777272
Opened: 1/23/2013 8:57:25 AM
Access Restriction: Public
User(s) can reproduce this bug


Running SQL 2012 SP1, 2 servers, 1 availability group. On Server B, where the replica state is secondary, if any user (including myself with sysadmin), right click on a local database, ie NOT IN THE AVAILABILITY GROUP, we get an error that states SSMS cannot show the requeted dialog box ... because database <not the database selected> is in an availability group, read only, etc.

I've check the SERVER STATE permissions (even though I'm sysadmin) and that's not the issue.

The error state is not consistent, but is frequent enough to reproduce more or less on demand, it comes and goes. my guess is this has to do with the interaction between SMO and the HADR specific management objects..
Sign in to post a comment.
Posted by Microsoft on 5/14/2013 at 1:32 PM
Hi, we were not able to repro. Please open a new issue with reference to this issue if this happens again. Please note the repro steps/info requested earlier posted.
Posted by Microsoft on 4/30/2013 at 1:18 PM
Hi Jeff,
We have been trying to repro this on an earlier and later build and were not able to reproduce this.
Can you provide us with some more information: 1) does this still repro? 2) Can you provide repro steps if you thinks this helps to repro this? 3) You indicate 'it comes and goes' -- can you capture the SQL queries emitted during success and failure and attach these? You can use SQL Profiler to accomplish this.
Sign in to post a workaround.