Creating SQL RDS instance in CloudFormation

Question

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 · Accepted Answer · 2013-10-17 22:21:16Z

3

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.

answered Oct 17, 2013 at 22:21

Ryan R Kennedy

463 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jonathan Over a year ago

I forgot to follow up and explain that this was exactly the problem - thanks Ryan. It turned out that EngineVersion wasn't required.

Pete - MSFT · Accepted Answer · 2013-08-30 02:12:18Z

1

You are missing EngineVersion - "EngineVersion" : "11.00.2100.60.v1",

Also - you'll need DBSecurityGRoups to be added.

answered Aug 30, 2013 at 2:12

Pete - MSFT

4,3301 gold badge23 silver badges38 bronze badges

Collectives™ on Stack Overflow

Creating SQL RDS instance in CloudFormation

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related