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

Status : 

  Not Reproducible<br /><br />
		The product team could not reproduce this item with the description and steps provided.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
0
Sign in
to vote
ID 777272 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 1/23/2013 8:57:25 AM
Access Restriction Public

Description

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 Michiel [MSFT] 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 Michiel [MSFT] 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.
Thanks,
Michiel