Found while investigating #110001.

Describe the problem

When TestStatusGossipJson in server/storage_api is modified to point to a secondary tenant (e.g. via #110008), the test starts failing when accessing the /_status/gossip endpoint:

    gossip_test.go:36: status: 501 Not Implemented, content-type: application/json, body: {
          "error": "method Gossip not implemented",
          "code": 12,
          "message": "method Gossip not implemented",
          "details": [
          ]

How to reproduce

from #110008 reset DefaultTestTenant in TestStatusGossipJson, run the test with a test tenant and observe the failure.

Expected behavior

Once the tenant is granted a suitable capability, the endpoint should work properly. It should retrieve the gossip info over the KV tenant connector over the network.

Epic CRDB-38968

Jira issue: CRDB-31227