MSSQLServer is the Schema for the MSSQLServers API. Manages a Microsoft SQL Azure Database Server.
Type
CRD
Group
sql.azure.upbound.io
Version
v1beta1
apiVersion: sql.azure.upbound.io/v1beta1
kind: MSSQLServer
MSSQLServerSpec defines the desired state of MSSQLServer
No description provided.
An azuread_administrator block as defined below.
Reference to a UserAssignedIdentity in managedidentity to populate loginUsername.
Policies for referencing.
Selector for a UserAssignedIdentity in managedidentity to populate loginUsername.
Policies for selection.
Reference to a UserAssignedIdentity in managedidentity to populate objectId.
Policies for referencing.
Selector for a UserAssignedIdentity in managedidentity to populate objectId.
Policies for selection.
An identity block as defined below.
Specifies a list of User Assigned Managed Identity IDs to be assigned to this SQL Server.
Reference to a UserAssignedIdentity in managedidentity to populate primaryUserAssignedIdentityId.
Policies for referencing.
Selector for a UserAssignedIdentity in managedidentity to populate primaryUserAssignedIdentityId.
Policies for selection.
Reference to a ResourceGroup in azure to populate resourceGroupName.
Policies for referencing.
Selector for a ResourceGroup in azure to populate resourceGroupName.
Policies for selection.
Reference to a Key in keyvault to populate transparentDataEncryptionKeyVaultKeyId.
Policies for referencing.
Selector for a Key in keyvault to populate transparentDataEncryptionKeyVaultKeyId.
Policies for selection.
THIS IS AN ALPHA FIELD. Do not use it in production. It is not honored unless the relevant Crossplane feature flag is enabled, and may be changed or removed without notice. InitProvider holds the same fields as ForProvider, with the exception of Identifier and other resource reference fields. The fields that are in InitProvider are merged into ForProvider when the resource is created. The same fields are also added to the terraform ignore_changes hook, to avoid updating them after creation. This is useful for fields that are required on creation, but we do not desire to update them after creation, for example because of an external controller is managing them, like an autoscaler.
An azuread_administrator block as defined below.
An identity block as defined below.
Specifies a list of User Assigned Managed Identity IDs to be assigned to this SQL Server.
THIS IS AN ALPHA FIELD. Do not use it in production. It is not honored unless the relevant Crossplane feature flag is enabled, and may be changed or removed without notice. ManagementPolicies specify the array of actions Crossplane is allowed to take on the managed and external resources. This field is planned to replace the DeletionPolicy field in a future release. Currently, both could be set independently and non-default values would be honored if the feature flag is enabled. If both are custom, the DeletionPolicy field will be ignored. See the design doc for more information: https://github.com/crossplane/crossplane/blob/499895a25d1a1a0ba1604944ef98ac7a1a71f197/design/design-doc-observe-only-resources.md?plain=1#L223 and this one: https://github.com/crossplane/crossplane/blob/444267e84783136daa93568b364a5f01228cacbe/design/one-pager-ignore-changes.md
ProviderConfigReference specifies how the provider that will be used to create, observe, update, and delete this managed resource should be configured.
Policies for referencing.
ProviderReference specifies the provider that will be used to create, observe, update, and delete this managed resource. Deprecated: Please use ProviderConfigReference, i.e. providerConfigRef
Policies for referencing.
PublishConnectionDetailsTo specifies the connection secret config which contains a name, metadata and a reference to secret store config to which any connection details for this managed resource should be written. Connection details frequently include the endpoint, username, and password required to connect to the managed resource.
WriteConnectionSecretToReference specifies the namespace and name of a Secret to which any connection details for this managed resource should be written. Connection details frequently include the endpoint, username, and password required to connect to the managed resource. This field is planned to be replaced in a future release in favor of PublishConnectionDetailsTo. Currently, both could be set independently and connection details would be published to both without affecting each other.
MSSQLServerStatus defines the observed state of MSSQLServer.
No description provided.
An azuread_administrator block as defined below.
An identity block as defined below.
Specifies a list of User Assigned Managed Identity IDs to be assigned to this SQL Server.
A list of dropped restorable database IDs on the server.
Conditions of the resource.
${Rand.RFC1123Subdomain}-secondary
apiVersion: sql.azure.upbound.io/v1beta1
kind: MSSQLServer
metadata:
annotations:
meta.upbound.io/example-id: sql/v1beta1/mssqlfailovergroup
labels:
testing.upbound.io/example-name: secondary
name: ${Rand.RFC1123Subdomain}-secondary
spec:
forProvider:
administratorLogin: missadministrator
administratorLoginPasswordSecretRef:
key: example-key
name: example-secret
namespace: upbound-system
location: North Europe
resourceGroupNameSelector:
matchLabels:
testing.upbound.io/example-name: example-sql-failover-secondary
version: "12.0"
${Rand.RFC1123Subdomain}-trans-enc
apiVersion: sql.azure.upbound.io/v1beta1
kind: MSSQLServer
metadata:
annotations:
meta.upbound.io/example-id: sql/v1beta1/mssqlservertransparentdataencryption
labels:
testing.upbound.io/example-name: example
name: ${Rand.RFC1123Subdomain}-trans-enc
spec:
forProvider:
administratorLogin: missadministrator
administratorLoginPasswordSecretRef:
key: example-key
name: example-secret
namespace: upbound-system
location: EastUs
minimumTlsVersion: "1.2"
resourceGroupNameSelector:
matchLabels:
testing.upbound.io/example-name: example-sql-trans-enc
tags:
environment: production
version: "12.0"
mssqlvulnassessment-srv
apiVersion: sql.azure.upbound.io/v1beta1
kind: MSSQLServer
metadata:
annotations:
meta.upbound.io/example-id: sql/v1beta1/mssqlservervulnerabilityassessment
upjet.upbound.io/manual-intervention: Requires existing blob storage path and key
labels:
testing.upbound.io/example-name: mssqlvulnassessment-srv
name: mssqlvulnassessment-srv
spec:
forProvider:
administratorLogin: 4dm1n157r470r
administratorLoginPasswordSecretRef:
key: example-key
name: example-secret
namespace: upbound-system
location: northeurope
resourceGroupNameSelector:
matchLabels:
testing.upbound.io/example-name: mssqlvulnassessment-rg
version: "12.0"
mssqljobcred-srv
apiVersion: sql.azure.upbound.io/v1beta1
kind: MSSQLServer
metadata:
annotations:
meta.upbound.io/example-id: sql/v1beta1/mssqljobcredential
labels:
testing.upbound.io/example-name: mssqljobcred-srv
name: mssqljobcred-srv
spec:
forProvider:
administratorLogin: 4dm1n157r470r
administratorLoginPasswordSecretRef:
key: example-key
name: example-secret
namespace: upbound-system
location: northeurope
resourceGroupNameSelector:
matchLabels:
testing.upbound.io/example-name: mssqljobcred-rg
version: "12.0"
mssqljobagent-srv
apiVersion: sql.azure.upbound.io/v1beta1
kind: MSSQLServer
metadata:
annotations:
meta.upbound.io/example-id: sql/v1beta1/mssqljobagent
labels:
testing.upbound.io/example-name: mssqljobagent-srv
name: mssqljobagent-srv
spec:
forProvider:
administratorLogin: 4dm1n157r470r
administratorLoginPasswordSecretRef:
key: example-key
name: example-secret
namespace: upbound-system
location: northeurope
resourceGroupNameSelector:
matchLabels:
testing.upbound.io/example-name: mssqljobagent-rg
version: "12.0"
mssqlservername
apiVersion: sql.azure.upbound.io/v1beta1
kind: MSSQLServer
metadata:
annotations:
meta.upbound.io/example-id: sql/v1beta1/mssqldatabaseextendedauditingpolicy
labels:
testing.upbound.io/example-name: example
name: mssqlservername
spec:
forProvider:
administratorLogin: missadministrator
administratorLoginPasswordSecretRef:
key: example-key
name: example-secret
namespace: upbound-system
location: West Europe
resourceGroupNameSelector:
matchLabels:
testing.upbound.io/example-name: example
version: "12.0"
dbrulebaseline-srv
apiVersion: sql.azure.upbound.io/v1beta1
kind: MSSQLServer
metadata:
annotations:
meta.upbound.io/example-id: sql/v1beta1/mssqldatabasevulnerabilityassessmentrulebaseline
upjet.upbound.io/manual-intervention: Requires existing blob storage path and key
labels:
testing.upbound.io/example-name: dbrulebaseline-srv
name: dbrulebaseline-srv
spec:
forProvider:
administratorLogin: 4dm1n157r470r
administratorLoginPasswordSecretRef:
key: example-key
name: example-secret
namespace: upbound-system
location: northeurope
resourceGroupNameSelector:
matchLabels:
testing.upbound.io/example-name: dbrulebaseline-rg
version: "12.0"
mssqlservername
apiVersion: sql.azure.upbound.io/v1beta1
kind: MSSQLServer
metadata:
annotations:
meta.upbound.io/example-id: streamanalytics/v1beta1/outputsynapse
labels:
testing.upbound.io/example-name: example
name: mssqlservername
spec:
forProvider:
administratorLogin: missadministrator
administratorLoginPasswordSecretRef:
key: example-key
name: example-secret
namespace: upbound-system
location: West Europe
resourceGroupNameSelector:
matchLabels:
testing.upbound.io/example-name: example
version: "12.0"
outputmysql
apiVersion: sql.azure.upbound.io/v1beta1
kind: MSSQLServer
metadata:
annotations:
meta.upbound.io/example-id: streamanalytics/v1beta1/outputmssql
labels:
testing.upbound.io/example-name: example
name: outputmysql
spec:
forProvider:
administratorLogin: missadministrator
administratorLoginPasswordSecretRef:
key: password
name: example-sql-server
namespace: upbound-system
location: West Europe
resourceGroupNameSelector:
matchLabels:
testing.upbound.io/example-name: example
version: "12.0"
mssqlelasticpoolsrv
apiVersion: sql.azure.upbound.io/v1beta1
kind: MSSQLServer
metadata:
annotations:
meta.upbound.io/example-id: sql/v1beta1/mssqlelasticpool
uptest.upbound.io/timeout: "3600"
labels:
testing.upbound.io/example-name: mssqlelasticpoolsrv
name: mssqlelasticpoolsrv
spec:
forProvider:
administratorLogin: 4dm1n157r470r
administratorLoginPasswordSecretRef:
key: example-key
name: example-secret
namespace: upbound-system
location: West Europe
resourceGroupNameSelector:
matchLabels:
testing.upbound.io/example-name: mssqlelasticpool-rg
version: "12.0"
example-vn-rule
apiVersion: sql.azure.upbound.io/v1beta1
kind: MSSQLServer
metadata:
annotations:
meta.upbound.io/example-id: sql/v1beta1/mssqlvirtualnetworkrule
labels:
testing.upbound.io/example-name: example-vn-rule
name: example-vn-rule
spec:
forProvider:
administratorLogin: 4dm1n157r470r
administratorLoginPasswordSecretRef:
key: password
name: example-secret
namespace: upbound-system
location: West Europe
resourceGroupNameSelector:
matchLabels:
testing.upbound.io/example-name: example-sql-vn-rule
version: "12.0"
${Rand.RFC1123Subdomain}-primary
apiVersion: sql.azure.upbound.io/v1beta1
kind: MSSQLServer
metadata:
annotations:
meta.upbound.io/example-id: sql/v1beta1/mssqlfailovergroup
labels:
testing.upbound.io/example-name: primary
name: ${Rand.RFC1123Subdomain}-primary
spec:
forProvider:
administratorLogin: missadministrator
administratorLoginPasswordSecretRef:
key: example-key
name: example-secret
namespace: upbound-system
location: West Europe
resourceGroupNameSelector:
matchLabels:
testing.upbound.io/example-name: example-sql-failover-primary
version: "12.0"
mssqlservername
apiVersion: sql.azure.upbound.io/v1beta1
kind: MSSQLServer
metadata:
annotations:
meta.upbound.io/example-id: sql/v1beta1/mssqlserversecurityalertpolicy
labels:
testing.upbound.io/example-name: example
name: mssqlservername
spec:
forProvider:
administratorLogin: missadministrator
administratorLoginPasswordSecretRef:
key: example-key
name: example-secret
namespace: upbound-system
location: West Europe
resourceGroupNameSelector:
matchLabels:
testing.upbound.io/example-name: example
version: "12.0"
refinputmssql-sqlsrv
apiVersion: sql.azure.upbound.io/v1beta1
kind: MSSQLServer
metadata:
annotations:
meta.upbound.io/example-id: streamanalytics/v1beta1/referenceinputmssql
labels:
testing.upbound.io/example-name: refinputmssql-sqlsrv
name: refinputmssql-sqlsrv
spec:
forProvider:
administratorLogin: exampleuser
administratorLoginPasswordSecretRef:
key: example-key
name: example-name
namespace: upbound-system
location: West Europe
resourceGroupNameSelector:
matchLabels:
testing.upbound.io/example-name: refinputmssql-rg
version: "12.0"
mssqlserv
apiVersion: sql.azure.upbound.io/v1beta1
kind: MSSQLServer
metadata:
annotations:
meta.upbound.io/example-id: sql/v1beta1/mssqlfirewallrule
labels:
testing.upbound.io/example-name: mssqlserv
name: mssqlserv
spec:
forProvider:
administratorLogin: 4dm1n157r470r
administratorLoginPasswordSecretRef:
key: example-key
name: example-secret
namespace: upbound-system
location: West Europe
resourceGroupNameSelector:
matchLabels:
testing.upbound.io/example-name: mssqlrg
version: "12.0"
${Rand.RFC1123Subdomain}-server
apiVersion: sql.azure.upbound.io/v1beta1
kind: MSSQLServer
metadata:
annotations:
meta.upbound.io/example-id: sql/v1beta1/mssqlservermicrosoftsupportauditingpolicy
labels:
testing.upbound.io/example-name: exampleserv0001
name: ${Rand.RFC1123Subdomain}-server
spec:
forProvider:
administratorLogin: missadministrator
administratorLoginPasswordSecretRef:
key: example-key
name: example-secret
namespace: upbound-system
location: West Europe
resourceGroupNameSelector:
matchLabels:
testing.upbound.io/example-name: rgauditingpolicy
version: "12.0"
© 2022 Upbound, Inc.
Discover the building blocksfor your internal cloud platform.