Creating SQL RDS instance in CloudFormation

Jonathan

I can't find any examples on creating a SQL Server RDS instance in CloudFormation, so I took an educated guess using an example for MySQL. Here's what I came up with:

{
    "AWSTemplateFormatVersion" : "2010-09-09",

    "Resources" : {
        "DBInstance" : {
            "Type": "AWS::RDS::DBInstance",
            "Properties": {
                "DBInstanceIdentifier"  : "test-db",
                "Engine"                : "sqlserver-ex",
                "Port"                  : "1433",
                "DBInstanceClass"       : "db.t1.micro",
                "AllocatedStorage"      : "30",
                "MasterUsername"        : "sa",
                "MasterUserPassword"    : "password"
            }
        }
    }
}

Unfortunately this doesn't work (CREATE_FAILED). Can anyone tell me why?

Ryan R Kennedy

In addition to Peter H's response... DBInstanceIdentifier is not a supported property. I would consult the cloudformation docs for which properties are and are not supported as well as the required properties. http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-rds-database-instance.html

Also... CloudFormation will tell you the reason it fails in the "Events" tab. One thing CloudFormation is really good at is telling you exactly why it failed.

この記事はインターネットから収集されたものであり、転載の際にはソースを示してください。

侵害の場合は、連絡してください[email protected]

編集
0

コメントを追加

0

関連記事

分類Dev

RDS does not support creating a DB instance with the following combination

分類Dev

Master user lost it's permissions unexpectedly on SQL Server (rds instance)

分類Dev

Is there any way to create triggers and stored procedures in an RDS MySQL instance at create time when creating an Elastic Beanstalk environment?

分類Dev

Creating an ALB Target Group in CloudFormation

分類Dev

Postgres Instance on RDS vs Aurora

分類Dev

Restoring an RDS Instance to a backup/snapshot

分類Dev

Creating RDS Instances from Snapshot Using Terraform

分類Dev

Cloudformationを使用してRdsを作成する

分類Dev

Creating CloudWatch rule with AWS CloudFormation not linking to role

分類Dev

Instance Size Flexibility for AWS RDS Reserved Instances

分類Dev

Create AWS RDS Instance with specific version?

分類Dev

How to change a RDS instance class on master instance with a read replica?

分類Dev

Disabling AWS RDS backups when creating/updating instances?

分類Dev

How to know the DB backup storage size for Amazon RDS instance

分類Dev

Connecting to Postgres AWS RDS Instance - "certificate verify failed"

分類Dev

How to change AWS-RDS instance type without downtime?

分類Dev

Unable to connect to MSSQL server on Amazon RDS using NAT instance

分類Dev

How to enable MultiAZ for an RDS Instance using Boto3?

分類Dev

Export Existing EC2 instance to CloudFormation json/yaml

分類Dev

Cloudformation AWS:RDSをサブネットに接続します

分類Dev

Cloudformation RDS Aurora:無効なストレージタイプ

分類Dev

AWS RDS Postgres replication to GCP cloud SQL

分類Dev

AWS RDS SQL Server failover really slow

分類Dev

how to inject an instance of configuration when creating instance of the injected class?

分類Dev

Ambiguous occurrence of == when creating a type as an instance of Eq

分類Dev

Creating a SQL totals table

分類Dev

Cloudformation-スタックのビルド時にRdsが失敗する

分類Dev

Creating a view in Sql with connected tables

分類Dev

Creating a List and parsing through it in SQL

Related 関連記事

  1. 1

    RDS does not support creating a DB instance with the following combination

  2. 2

    Master user lost it's permissions unexpectedly on SQL Server (rds instance)

  3. 3

    Is there any way to create triggers and stored procedures in an RDS MySQL instance at create time when creating an Elastic Beanstalk environment?

  4. 4

    Creating an ALB Target Group in CloudFormation

  5. 5

    Postgres Instance on RDS vs Aurora

  6. 6

    Restoring an RDS Instance to a backup/snapshot

  7. 7

    Creating RDS Instances from Snapshot Using Terraform

  8. 8

    Cloudformationを使用してRdsを作成する

  9. 9

    Creating CloudWatch rule with AWS CloudFormation not linking to role

  10. 10

    Instance Size Flexibility for AWS RDS Reserved Instances

  11. 11

    Create AWS RDS Instance with specific version?

  12. 12

    How to change a RDS instance class on master instance with a read replica?

  13. 13

    Disabling AWS RDS backups when creating/updating instances?

  14. 14

    How to know the DB backup storage size for Amazon RDS instance

  15. 15

    Connecting to Postgres AWS RDS Instance - "certificate verify failed"

  16. 16

    How to change AWS-RDS instance type without downtime?

  17. 17

    Unable to connect to MSSQL server on Amazon RDS using NAT instance

  18. 18

    How to enable MultiAZ for an RDS Instance using Boto3?

  19. 19

    Export Existing EC2 instance to CloudFormation json/yaml

  20. 20

    Cloudformation AWS:RDSをサブネットに接続します

  21. 21

    Cloudformation RDS Aurora:無効なストレージタイプ

  22. 22

    AWS RDS Postgres replication to GCP cloud SQL

  23. 23

    AWS RDS SQL Server failover really slow

  24. 24

    how to inject an instance of configuration when creating instance of the injected class?

  25. 25

    Ambiguous occurrence of == when creating a type as an instance of Eq

  26. 26

    Creating a SQL totals table

  27. 27

    Cloudformation-スタックのビルド時にRdsが失敗する

  28. 28

    Creating a view in Sql with connected tables

  29. 29

    Creating a List and parsing through it in SQL

ホットタグ

アーカイブ