Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi Cloud Packages Tutorials
  1. Packages
  2. Akeyless Provider
  3. API Docs
  4. ProducerMssql
akeyless 1.9.0 published on Monday, Apr 14, 2025 by akeyless-community
akeyless-community/terraform-provider-akeyless

akeyless.ProducerMssql

Explore with Pulumi AI

akeyless 1.9.0 published on Monday, Apr 14, 2025 by akeyless-community
akeyless-community/terraform-provider-akeyless

Microsoft SQL Server producer resource

Create ProducerMssql Resource

Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

Constructor syntax

new ProducerMssql(name: string, args?: ProducerMssqlArgs, opts?: CustomResourceOptions);
@overload
def ProducerMssql(resource_name: str,
                  args: Optional[ProducerMssqlArgs] = None,
                  opts: Optional[ResourceOptions] = None)

@overload
def ProducerMssql(resource_name: str,
                  opts: Optional[ResourceOptions] = None,
                  mssql_create_statements: Optional[str] = None,
                  mssql_dbname: Optional[str] = None,
                  mssql_host: Optional[str] = None,
                  mssql_password: Optional[str] = None,
                  mssql_port: Optional[str] = None,
                  mssql_revocation_statements: Optional[str] = None,
                  mssql_username: Optional[str] = None,
                  name: Optional[str] = None,
                  producer_encryption_key_name: Optional[str] = None,
                  producer_mssql_id: Optional[str] = None,
                  secure_access_bastion_issuer: Optional[str] = None,
                  secure_access_db_name: Optional[str] = None,
                  secure_access_db_schema: Optional[str] = None,
                  secure_access_enable: Optional[str] = None,
                  secure_access_hosts: Optional[Sequence[str]] = None,
                  secure_access_web: Optional[bool] = None,
                  tags: Optional[Sequence[str]] = None,
                  target_name: Optional[str] = None,
                  user_ttl: Optional[str] = None)
func NewProducerMssql(ctx *Context, name string, args *ProducerMssqlArgs, opts ...ResourceOption) (*ProducerMssql, error)
public ProducerMssql(string name, ProducerMssqlArgs? args = null, CustomResourceOptions? opts = null)
public ProducerMssql(String name, ProducerMssqlArgs args)
public ProducerMssql(String name, ProducerMssqlArgs args, CustomResourceOptions options)

type: akeyless:ProducerMssql
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

Parameters

name This property is required. string
The unique name of the resource.
args ProducerMssqlArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
resource_name This property is required. str
The unique name of the resource.
args ProducerMssqlArgs
The arguments to resource properties.
opts ResourceOptions
Bag of options to control resource's behavior.
ctx Context
Context object for the current deployment.
name This property is required. string
The unique name of the resource.
args ProducerMssqlArgs
The arguments to resource properties.
opts ResourceOption
Bag of options to control resource's behavior.
name This property is required. string
The unique name of the resource.
args ProducerMssqlArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
name This property is required. String
The unique name of the resource.
args This property is required. ProducerMssqlArgs
The arguments to resource properties.
options CustomResourceOptions
Bag of options to control resource's behavior.

Constructor example

The following reference example uses placeholder values for all input properties.

var producerMssqlResource = new Akeyless.ProducerMssql("producerMssqlResource", new()
{
    MssqlCreateStatements = "string",
    MssqlDbname = "string",
    MssqlHost = "string",
    MssqlPassword = "string",
    MssqlPort = "string",
    MssqlRevocationStatements = "string",
    MssqlUsername = "string",
    Name = "string",
    ProducerEncryptionKeyName = "string",
    ProducerMssqlId = "string",
    SecureAccessBastionIssuer = "string",
    SecureAccessDbName = "string",
    SecureAccessDbSchema = "string",
    SecureAccessEnable = "string",
    SecureAccessHosts = new[]
    {
        "string",
    },
    SecureAccessWeb = false,
    Tags = new[]
    {
        "string",
    },
    TargetName = "string",
    UserTtl = "string",
});
Copy
example, err := akeyless.NewProducerMssql(ctx, "producerMssqlResource", &akeyless.ProducerMssqlArgs{
MssqlCreateStatements: pulumi.String("string"),
MssqlDbname: pulumi.String("string"),
MssqlHost: pulumi.String("string"),
MssqlPassword: pulumi.String("string"),
MssqlPort: pulumi.String("string"),
MssqlRevocationStatements: pulumi.String("string"),
MssqlUsername: pulumi.String("string"),
Name: pulumi.String("string"),
ProducerEncryptionKeyName: pulumi.String("string"),
ProducerMssqlId: pulumi.String("string"),
SecureAccessBastionIssuer: pulumi.String("string"),
SecureAccessDbName: pulumi.String("string"),
SecureAccessDbSchema: pulumi.String("string"),
SecureAccessEnable: pulumi.String("string"),
SecureAccessHosts: pulumi.StringArray{
pulumi.String("string"),
},
SecureAccessWeb: pulumi.Bool(false),
Tags: pulumi.StringArray{
pulumi.String("string"),
},
TargetName: pulumi.String("string"),
UserTtl: pulumi.String("string"),
})
Copy
var producerMssqlResource = new ProducerMssql("producerMssqlResource", ProducerMssqlArgs.builder()
    .mssqlCreateStatements("string")
    .mssqlDbname("string")
    .mssqlHost("string")
    .mssqlPassword("string")
    .mssqlPort("string")
    .mssqlRevocationStatements("string")
    .mssqlUsername("string")
    .name("string")
    .producerEncryptionKeyName("string")
    .producerMssqlId("string")
    .secureAccessBastionIssuer("string")
    .secureAccessDbName("string")
    .secureAccessDbSchema("string")
    .secureAccessEnable("string")
    .secureAccessHosts("string")
    .secureAccessWeb(false)
    .tags("string")
    .targetName("string")
    .userTtl("string")
    .build());
Copy
producer_mssql_resource = akeyless.ProducerMssql("producerMssqlResource",
    mssql_create_statements="string",
    mssql_dbname="string",
    mssql_host="string",
    mssql_password="string",
    mssql_port="string",
    mssql_revocation_statements="string",
    mssql_username="string",
    name="string",
    producer_encryption_key_name="string",
    producer_mssql_id="string",
    secure_access_bastion_issuer="string",
    secure_access_db_name="string",
    secure_access_db_schema="string",
    secure_access_enable="string",
    secure_access_hosts=["string"],
    secure_access_web=False,
    tags=["string"],
    target_name="string",
    user_ttl="string")
Copy
const producerMssqlResource = new akeyless.ProducerMssql("producerMssqlResource", {
    mssqlCreateStatements: "string",
    mssqlDbname: "string",
    mssqlHost: "string",
    mssqlPassword: "string",
    mssqlPort: "string",
    mssqlRevocationStatements: "string",
    mssqlUsername: "string",
    name: "string",
    producerEncryptionKeyName: "string",
    producerMssqlId: "string",
    secureAccessBastionIssuer: "string",
    secureAccessDbName: "string",
    secureAccessDbSchema: "string",
    secureAccessEnable: "string",
    secureAccessHosts: ["string"],
    secureAccessWeb: false,
    tags: ["string"],
    targetName: "string",
    userTtl: "string",
});
Copy
type: akeyless:ProducerMssql
properties:
    mssqlCreateStatements: string
    mssqlDbname: string
    mssqlHost: string
    mssqlPassword: string
    mssqlPort: string
    mssqlRevocationStatements: string
    mssqlUsername: string
    name: string
    producerEncryptionKeyName: string
    producerMssqlId: string
    secureAccessBastionIssuer: string
    secureAccessDbName: string
    secureAccessDbSchema: string
    secureAccessEnable: string
    secureAccessHosts:
        - string
    secureAccessWeb: false
    tags:
        - string
    targetName: string
    userTtl: string
Copy

ProducerMssql Resource Properties

To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

Inputs

In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

The ProducerMssql resource accepts the following input properties:

MssqlCreateStatements string
MSSQL Server Creation Statements
MssqlDbname string
MSSQL Server DB Name
MssqlHost string
MS SQL Server host name
MssqlPassword string
MS SQL Server password
MssqlPort string
MS SQL Server port
MssqlRevocationStatements string
MSSQL Server Revocation Statements
MssqlUsername string
MS SQL Server user
Name string
Producer name
ProducerEncryptionKeyName string
Encrypt producer with following key
ProducerMssqlId string
The ID of this resource.
SecureAccessBastionIssuer string
Path to the SSH Certificate Issuer for your Akeyless Bastion
SecureAccessDbName string
Enable Web Secure Remote Access
SecureAccessDbSchema string
The db schema
SecureAccessEnable string
Enable/Disable secure remote access, [true/false]
SecureAccessHosts List<string>
Target DB servers for connections., For multiple values repeat this flag.
SecureAccessWeb bool
Enable Web Secure Remote Access
Tags List<string>
List of the tags attached to this secret. To specify multiple tags use argument multiple times: -t Tag1 -t Tag2
TargetName string
Name of existing target to use in producer creation
UserTtl string
User TTL
MssqlCreateStatements string
MSSQL Server Creation Statements
MssqlDbname string
MSSQL Server DB Name
MssqlHost string
MS SQL Server host name
MssqlPassword string
MS SQL Server password
MssqlPort string
MS SQL Server port
MssqlRevocationStatements string
MSSQL Server Revocation Statements
MssqlUsername string
MS SQL Server user
Name string
Producer name
ProducerEncryptionKeyName string
Encrypt producer with following key
ProducerMssqlId string
The ID of this resource.
SecureAccessBastionIssuer string
Path to the SSH Certificate Issuer for your Akeyless Bastion
SecureAccessDbName string
Enable Web Secure Remote Access
SecureAccessDbSchema string
The db schema
SecureAccessEnable string
Enable/Disable secure remote access, [true/false]
SecureAccessHosts []string
Target DB servers for connections., For multiple values repeat this flag.
SecureAccessWeb bool
Enable Web Secure Remote Access
Tags []string
List of the tags attached to this secret. To specify multiple tags use argument multiple times: -t Tag1 -t Tag2
TargetName string
Name of existing target to use in producer creation
UserTtl string
User TTL
mssqlCreateStatements String
MSSQL Server Creation Statements
mssqlDbname String
MSSQL Server DB Name
mssqlHost String
MS SQL Server host name
mssqlPassword String
MS SQL Server password
mssqlPort String
MS SQL Server port
mssqlRevocationStatements String
MSSQL Server Revocation Statements
mssqlUsername String
MS SQL Server user
name String
Producer name
producerEncryptionKeyName String
Encrypt producer with following key
producerMssqlId String
The ID of this resource.
secureAccessBastionIssuer String
Path to the SSH Certificate Issuer for your Akeyless Bastion
secureAccessDbName String
Enable Web Secure Remote Access
secureAccessDbSchema String
The db schema
secureAccessEnable String
Enable/Disable secure remote access, [true/false]
secureAccessHosts List<String>
Target DB servers for connections., For multiple values repeat this flag.
secureAccessWeb Boolean
Enable Web Secure Remote Access
tags List<String>
List of the tags attached to this secret. To specify multiple tags use argument multiple times: -t Tag1 -t Tag2
targetName String
Name of existing target to use in producer creation
userTtl String
User TTL
mssqlCreateStatements string
MSSQL Server Creation Statements
mssqlDbname string
MSSQL Server DB Name
mssqlHost string
MS SQL Server host name
mssqlPassword string
MS SQL Server password
mssqlPort string
MS SQL Server port
mssqlRevocationStatements string
MSSQL Server Revocation Statements
mssqlUsername string
MS SQL Server user
name string
Producer name
producerEncryptionKeyName string
Encrypt producer with following key
producerMssqlId string
The ID of this resource.
secureAccessBastionIssuer string
Path to the SSH Certificate Issuer for your Akeyless Bastion
secureAccessDbName string
Enable Web Secure Remote Access
secureAccessDbSchema string
The db schema
secureAccessEnable string
Enable/Disable secure remote access, [true/false]
secureAccessHosts string[]
Target DB servers for connections., For multiple values repeat this flag.
secureAccessWeb boolean
Enable Web Secure Remote Access
tags string[]
List of the tags attached to this secret. To specify multiple tags use argument multiple times: -t Tag1 -t Tag2
targetName string
Name of existing target to use in producer creation
userTtl string
User TTL
mssql_create_statements str
MSSQL Server Creation Statements
mssql_dbname str
MSSQL Server DB Name
mssql_host str
MS SQL Server host name
mssql_password str
MS SQL Server password
mssql_port str
MS SQL Server port
mssql_revocation_statements str
MSSQL Server Revocation Statements
mssql_username str
MS SQL Server user
name str
Producer name
producer_encryption_key_name str
Encrypt producer with following key
producer_mssql_id str
The ID of this resource.
secure_access_bastion_issuer str
Path to the SSH Certificate Issuer for your Akeyless Bastion
secure_access_db_name str
Enable Web Secure Remote Access
secure_access_db_schema str
The db schema
secure_access_enable str
Enable/Disable secure remote access, [true/false]
secure_access_hosts Sequence[str]
Target DB servers for connections., For multiple values repeat this flag.
secure_access_web bool
Enable Web Secure Remote Access
tags Sequence[str]
List of the tags attached to this secret. To specify multiple tags use argument multiple times: -t Tag1 -t Tag2
target_name str
Name of existing target to use in producer creation
user_ttl str
User TTL
mssqlCreateStatements String
MSSQL Server Creation Statements
mssqlDbname String
MSSQL Server DB Name
mssqlHost String
MS SQL Server host name
mssqlPassword String
MS SQL Server password
mssqlPort String
MS SQL Server port
mssqlRevocationStatements String
MSSQL Server Revocation Statements
mssqlUsername String
MS SQL Server user
name String
Producer name
producerEncryptionKeyName String
Encrypt producer with following key
producerMssqlId String
The ID of this resource.
secureAccessBastionIssuer String
Path to the SSH Certificate Issuer for your Akeyless Bastion
secureAccessDbName String
Enable Web Secure Remote Access
secureAccessDbSchema String
The db schema
secureAccessEnable String
Enable/Disable secure remote access, [true/false]
secureAccessHosts List<String>
Target DB servers for connections., For multiple values repeat this flag.
secureAccessWeb Boolean
Enable Web Secure Remote Access
tags List<String>
List of the tags attached to this secret. To specify multiple tags use argument multiple times: -t Tag1 -t Tag2
targetName String
Name of existing target to use in producer creation
userTtl String
User TTL

Outputs

All input properties are implicitly available as output properties. Additionally, the ProducerMssql resource produces the following output properties:

Id string
The provider-assigned unique ID for this managed resource.
Id string
The provider-assigned unique ID for this managed resource.
id String
The provider-assigned unique ID for this managed resource.
id string
The provider-assigned unique ID for this managed resource.
id str
The provider-assigned unique ID for this managed resource.
id String
The provider-assigned unique ID for this managed resource.

Look up Existing ProducerMssql Resource

Get an existing ProducerMssql resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

public static get(name: string, id: Input<ID>, state?: ProducerMssqlState, opts?: CustomResourceOptions): ProducerMssql
@staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        mssql_create_statements: Optional[str] = None,
        mssql_dbname: Optional[str] = None,
        mssql_host: Optional[str] = None,
        mssql_password: Optional[str] = None,
        mssql_port: Optional[str] = None,
        mssql_revocation_statements: Optional[str] = None,
        mssql_username: Optional[str] = None,
        name: Optional[str] = None,
        producer_encryption_key_name: Optional[str] = None,
        producer_mssql_id: Optional[str] = None,
        secure_access_bastion_issuer: Optional[str] = None,
        secure_access_db_name: Optional[str] = None,
        secure_access_db_schema: Optional[str] = None,
        secure_access_enable: Optional[str] = None,
        secure_access_hosts: Optional[Sequence[str]] = None,
        secure_access_web: Optional[bool] = None,
        tags: Optional[Sequence[str]] = None,
        target_name: Optional[str] = None,
        user_ttl: Optional[str] = None) -> ProducerMssql
func GetProducerMssql(ctx *Context, name string, id IDInput, state *ProducerMssqlState, opts ...ResourceOption) (*ProducerMssql, error)
public static ProducerMssql Get(string name, Input<string> id, ProducerMssqlState? state, CustomResourceOptions? opts = null)
public static ProducerMssql get(String name, Output<String> id, ProducerMssqlState state, CustomResourceOptions options)
resources:  _:    type: akeyless:ProducerMssql    get:      id: ${id}
name This property is required.
The unique name of the resulting resource.
id This property is required.
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
resource_name This property is required.
The unique name of the resulting resource.
id This property is required.
The unique provider ID of the resource to lookup.
name This property is required.
The unique name of the resulting resource.
id This property is required.
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
name This property is required.
The unique name of the resulting resource.
id This property is required.
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
name This property is required.
The unique name of the resulting resource.
id This property is required.
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
The following state arguments are supported:
MssqlCreateStatements string
MSSQL Server Creation Statements
MssqlDbname string
MSSQL Server DB Name
MssqlHost string
MS SQL Server host name
MssqlPassword string
MS SQL Server password
MssqlPort string
MS SQL Server port
MssqlRevocationStatements string
MSSQL Server Revocation Statements
MssqlUsername string
MS SQL Server user
Name string
Producer name
ProducerEncryptionKeyName string
Encrypt producer with following key
ProducerMssqlId string
The ID of this resource.
SecureAccessBastionIssuer string
Path to the SSH Certificate Issuer for your Akeyless Bastion
SecureAccessDbName string
Enable Web Secure Remote Access
SecureAccessDbSchema string
The db schema
SecureAccessEnable string
Enable/Disable secure remote access, [true/false]
SecureAccessHosts List<string>
Target DB servers for connections., For multiple values repeat this flag.
SecureAccessWeb bool
Enable Web Secure Remote Access
Tags List<string>
List of the tags attached to this secret. To specify multiple tags use argument multiple times: -t Tag1 -t Tag2
TargetName string
Name of existing target to use in producer creation
UserTtl string
User TTL
MssqlCreateStatements string
MSSQL Server Creation Statements
MssqlDbname string
MSSQL Server DB Name
MssqlHost string
MS SQL Server host name
MssqlPassword string
MS SQL Server password
MssqlPort string
MS SQL Server port
MssqlRevocationStatements string
MSSQL Server Revocation Statements
MssqlUsername string
MS SQL Server user
Name string
Producer name
ProducerEncryptionKeyName string
Encrypt producer with following key
ProducerMssqlId string
The ID of this resource.
SecureAccessBastionIssuer string
Path to the SSH Certificate Issuer for your Akeyless Bastion
SecureAccessDbName string
Enable Web Secure Remote Access
SecureAccessDbSchema string
The db schema
SecureAccessEnable string
Enable/Disable secure remote access, [true/false]
SecureAccessHosts []string
Target DB servers for connections., For multiple values repeat this flag.
SecureAccessWeb bool
Enable Web Secure Remote Access
Tags []string
List of the tags attached to this secret. To specify multiple tags use argument multiple times: -t Tag1 -t Tag2
TargetName string
Name of existing target to use in producer creation
UserTtl string
User TTL
mssqlCreateStatements String
MSSQL Server Creation Statements
mssqlDbname String
MSSQL Server DB Name
mssqlHost String
MS SQL Server host name
mssqlPassword String
MS SQL Server password
mssqlPort String
MS SQL Server port
mssqlRevocationStatements String
MSSQL Server Revocation Statements
mssqlUsername String
MS SQL Server user
name String
Producer name
producerEncryptionKeyName String
Encrypt producer with following key
producerMssqlId String
The ID of this resource.
secureAccessBastionIssuer String
Path to the SSH Certificate Issuer for your Akeyless Bastion
secureAccessDbName String
Enable Web Secure Remote Access
secureAccessDbSchema String
The db schema
secureAccessEnable String
Enable/Disable secure remote access, [true/false]
secureAccessHosts List<String>
Target DB servers for connections., For multiple values repeat this flag.
secureAccessWeb Boolean
Enable Web Secure Remote Access
tags List<String>
List of the tags attached to this secret. To specify multiple tags use argument multiple times: -t Tag1 -t Tag2
targetName String
Name of existing target to use in producer creation
userTtl String
User TTL
mssqlCreateStatements string
MSSQL Server Creation Statements
mssqlDbname string
MSSQL Server DB Name
mssqlHost string
MS SQL Server host name
mssqlPassword string
MS SQL Server password
mssqlPort string
MS SQL Server port
mssqlRevocationStatements string
MSSQL Server Revocation Statements
mssqlUsername string
MS SQL Server user
name string
Producer name
producerEncryptionKeyName string
Encrypt producer with following key
producerMssqlId string
The ID of this resource.
secureAccessBastionIssuer string
Path to the SSH Certificate Issuer for your Akeyless Bastion
secureAccessDbName string
Enable Web Secure Remote Access
secureAccessDbSchema string
The db schema
secureAccessEnable string
Enable/Disable secure remote access, [true/false]
secureAccessHosts string[]
Target DB servers for connections., For multiple values repeat this flag.
secureAccessWeb boolean
Enable Web Secure Remote Access
tags string[]
List of the tags attached to this secret. To specify multiple tags use argument multiple times: -t Tag1 -t Tag2
targetName string
Name of existing target to use in producer creation
userTtl string
User TTL
mssql_create_statements str
MSSQL Server Creation Statements
mssql_dbname str
MSSQL Server DB Name
mssql_host str
MS SQL Server host name
mssql_password str
MS SQL Server password
mssql_port str
MS SQL Server port
mssql_revocation_statements str
MSSQL Server Revocation Statements
mssql_username str
MS SQL Server user
name str
Producer name
producer_encryption_key_name str
Encrypt producer with following key
producer_mssql_id str
The ID of this resource.
secure_access_bastion_issuer str
Path to the SSH Certificate Issuer for your Akeyless Bastion
secure_access_db_name str
Enable Web Secure Remote Access
secure_access_db_schema str
The db schema
secure_access_enable str
Enable/Disable secure remote access, [true/false]
secure_access_hosts Sequence[str]
Target DB servers for connections., For multiple values repeat this flag.
secure_access_web bool
Enable Web Secure Remote Access
tags Sequence[str]
List of the tags attached to this secret. To specify multiple tags use argument multiple times: -t Tag1 -t Tag2
target_name str
Name of existing target to use in producer creation
user_ttl str
User TTL
mssqlCreateStatements String
MSSQL Server Creation Statements
mssqlDbname String
MSSQL Server DB Name
mssqlHost String
MS SQL Server host name
mssqlPassword String
MS SQL Server password
mssqlPort String
MS SQL Server port
mssqlRevocationStatements String
MSSQL Server Revocation Statements
mssqlUsername String
MS SQL Server user
name String
Producer name
producerEncryptionKeyName String
Encrypt producer with following key
producerMssqlId String
The ID of this resource.
secureAccessBastionIssuer String
Path to the SSH Certificate Issuer for your Akeyless Bastion
secureAccessDbName String
Enable Web Secure Remote Access
secureAccessDbSchema String
The db schema
secureAccessEnable String
Enable/Disable secure remote access, [true/false]
secureAccessHosts List<String>
Target DB servers for connections., For multiple values repeat this flag.
secureAccessWeb Boolean
Enable Web Secure Remote Access
tags List<String>
List of the tags attached to this secret. To specify multiple tags use argument multiple times: -t Tag1 -t Tag2
targetName String
Name of existing target to use in producer creation
userTtl String
User TTL

Package Details

Repository
akeyless akeyless-community/terraform-provider-akeyless
License
Notes
This Pulumi package is based on the akeyless Terraform Provider.
akeyless 1.9.0 published on Monday, Apr 14, 2025 by akeyless-community
akeyless-community/terraform-provider-akeyless