This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 54%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Failed to retrieve data for this request.(Microsoft.SQLServer.Management.sdk.sfc)
Are you seeking help or did you just jott down a note in the first empty space you found?
If you are seeking help, you need to include context about what you are trying to do and the complete error message.
Hi @Mohammad Abid (SONATA SOFTWARE NORTH AMERICA INC)
This error may happen because of various reasons. Please post more details.
Failed to retrieve data for this request.(Microsoft.SQLServer.Management.sdk.sfc)
an exception occurred while executing a transact-SQL statement or batch. (Microsoft.SQLServer.ConnnectionInfo)
Target database, 'master',is participating in an availability group and is currently not accessible for quries. Either data movement is suspended or the availability replica is not enabled for read access. To allow read-only access to this and other databases in the availability group, enable read access to one or more secondary availability replicas in the group. For more information, are the ALTER AVAILBILITY GROUP statement in SQL Server Book Online. ( Microsoft SQL Server, Error:976)
Seems like that you have a contained availability group, and you are connecting to the secondary rather than the primary.
Yeah, your title says "Listener issue", so I guess that you are connecting to a listener. Then again, might this be a clusterless availability group?
Anyway, please explain why you don't expect to get this error message and what troubleshooting you have conducted.