当使用Terraform配置AWS Microsoft SQL时,会出现InvalidParameterCombination错误。这是因为Terraform在配置时使用了不正确的参数组合。通常,这是由于未正确设置Terraform模板中的参数所导致的。
为了解决此问题,您可以使用以下代码示例:
resource "aws_db_instance" "example" {
engine = "sqlserver-ex"
engine_version = "13.00.4422.0.v1"
identifier = "${var.identifier}"
instance_class = "${var.instance_class}"
allocated_storage = "${var.allocated_storage}"
name = "${var.name}"
username = "${var.username}"
password = "${var.password}"
multi_az = "${var.multi_az}"
backup_retention_period = "${var.backup_retention_period}"
preferred_backup_window = "${var.preferred_backup_window}"
preferred_maintenance_window = "${var.preferred_maintenance_window}"
vpc_security_group_ids = ["${var.vpc_security_group_ids}"]
tags = {
Environment = "${var.environment}"
}
parameter_group_name = "${aws_db_parameter_group.example.name}"
}
resource "aws_db_parameter_group" "example" {
family = "sqlserver-ex"
name = "${var.parameter_group_name}"
description = "${var.description}"
parameter {
name = "sp_configure"
value = "1"
apply_method = "pending-reboot"
}
parameter {
name = "max_worker_threads"
value = "1024"
apply_method = "pending-reboot"
}
}
variable "name" {}
variable "username" {}
variable "password" {}
variable "engine" {}
variable "engine_version" {}
variable "identifier" {}
variable "allocated_storage" {}
variable "instance_class" {}
variable "multi_az" {}
variable "backup_retention_period" {}
variable "preferred_backup_window" {}
variable "preferred_maintenance_window" {}
variable "vpc_security_group_ids" {}
variable "environment" {}
variable "parameter_group_name" {}
variable "description" {}
在这个例子中,我们