listener issue

Question

listener issue

Anonymous

Failed to retrieve data for this request.(Microsoft.SQLServer.Management.sdk.sfc)

Erland Sommarskog 133.7K Reputation points MVP Volunteer Moderator

2025-02-27T22:48:44.39+00:00

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.
LiHongMSFT-4306 31,621 Reputation points

2025-02-28T01:46:50.4033333+00:00

Hi @Mohammad Abid (SONATA SOFTWARE NORTH AMERICA INC)

This error may happen because of various reasons. Please post more details.
Anonymous

2025-02-28T09:02:40.9133333+00:00

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)
Erland Sommarskog 133.7K Reputation points MVP Volunteer Moderator

2025-02-28T20:31:41.8566667+00:00

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.