Server Trust Certificates - List By Instance

Gets a list of server trust certificates that were uploaded from box to the given Sql Managed Instance.

GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/managedInstances/{managedInstanceName}/serverTrustCertificates?api-version=2021-11-01

URI Parameters

Name In Required Type Description
managedInstanceName
path True

string

The name of the managed instance.

resourceGroupName
path True

string

The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

subscriptionId
path True

string

The subscription ID that identifies an Azure subscription.

api-version
query True

string

The API version to use for the request.

Responses

Name Type Description
200 OK

ServerTrustCertificatesListResult

Successfully retrieved a list of server trust certificates.

Other Status Codes

*** Error Responses: ***

  • 404 SubscriptionDoesNotHaveServer - The requested server was not found

  • 404 ServerNotInSubscriptionResourceGroup - Specified server does not exist in the specified resource group and subscription.

Examples

Gets a list of server trust certificates on a given server.

Sample request

GET https://management.azure.com/subscriptions/38e0dc56-907f-45ba-a97c-74233baad471/resourceGroups/testrg/providers/Microsoft.Sql/managedInstances/testcl/serverTrustCertificates?api-version=2021-11-01

Sample response

{
  "value": [
    {
      "properties": {
        "thumbprint": "33702D20EC861199852837AE6BD1A71544B681E2",
        "certificateName": "customerCertificate1"
      },
      "id": "/subscriptions/38e0dc56-907f-45ba-a97c-74233baad471/resourceGroups/testrg/providers/Microsoft.Sql/managedInstances/testcl/serverTrustCertificates/customerCertificate1",
      "name": "customerCertificate1",
      "type": "Microsoft.Sql/managedInstances/serverTrustCertificates"
    },
    {
      "properties": {
        "thumbprint": "57CFA9CF16F2FB2775AF059A95C6D5B897DA2C05",
        "certificateName": "customerCertificate2"
      },
      "id": "/subscriptions/38e0dc56-907f-45ba-a97c-74233baad471/resourceGroups/testrg/providers/Microsoft.Sql/managedInstances/testcl/serverTrustCertificates/customerCertificate2",
      "name": "customerCertificate2",
      "type": "Microsoft.Sql/managedInstances/serverTrustCertificates"
    }
  ]
}

Definitions

Name Description
ServerTrustCertificate

Server trust certificate imported from box to enable connection between box and Sql Managed Instance.

ServerTrustCertificatesListResult

A list of server trust certificates in instance.

ServerTrustCertificate

Server trust certificate imported from box to enable connection between box and Sql Managed Instance.

Name Type Description
id

string

Resource ID.

name

string

Resource name.

properties.certificateName

string

The certificate name

properties.publicBlob

string

The certificate public blob

properties.thumbprint

string

The certificate thumbprint

type

string

Resource type.

ServerTrustCertificatesListResult

A list of server trust certificates in instance.

Name Type Description
nextLink

string

Link to retrieve next page of results.

value

ServerTrustCertificate[]

Array of results.