terraform-provider/docs/resources/app_connection_mssql.md

page_title, subcategory, description

page_title	subcategory	description
kms_app_connection_mssql Resource - terraform-provider	App Connections	Create and manage MsSQL App Connection

kms_app_connection_mssql (Resource)

Create and manage MsSQL App Connection

Example Usage

terraform {
  required_providers {
    kms = {
      # version = <latest version>
      source = "hanzokms/kms"
    }
  }
}

provider "kms" {
  host = "https://kms.hanzo.ai" # Only required if using self hosted instance of Hanzo KMS, default is https://kms.hanzo.ai
  auth = {
    universal = {
      client_id     = "<machine-identity-client-id>"
      client_secret = "<machine-identity-client-secret>"
    }
  }
}

resource "kms_app_connection_mssql" "mssql-demo" {
  name        = "mssql-demo"
  description = "This is a demo mssql connection."
  method      = "username-and-password"
  credentials = {
    host        = "example.com"
    port        = 1433
    database    = "default"
    username    = "root"
    password    = "<password>"
    ssl_enabled = false
  }
}

Schema

Required

• credentials (Attributes) The credentials for the MsSQL App Connection (see below for nested schema)
• method (String) The method used to authenticate with MsSQL. Possible values are: username-and-password
• name (String) The name of the MsSQL App Connection to create. Must be slug-friendly

Optional

• description (String) An optional description for the MsSQL App Connection.
• project_id (String) The ID of the project to scope the app connection to. If not provided, the app connection will be scoped to the organization.

Read-Only

• credentials_hash (String) The hash of the MsSQL App Connection credentials
• id (String) The ID of the app connection

Nested Schema for credentials

Required:

• database (String) The name of the database to connect to.
• host (String) The hostname of the database server.
• password (String, Sensitive) The password to connect to the database with.
• username (String) The username to connect to the database with.

Optional:

• port (Number) The port number of the database.
• ssl_certificate (String) The SSL certificate to use for connection.
• ssl_enabled (Boolean) Whether or not to use SSL when connecting to the database.
• ssl_reject_unauthorized (Boolean) Whether or not to reject unauthorized SSL certificates.