RDS custom - Incompatible-create

Question

Hello,

I have the trouble with create a new Custom RDS for MSSqlSever,
always when i create i have recent event : You can't create the DB instance because of incompatible resources. "Role attached to instance-profile [AWSRDSCustom-wms] missing required permission, cause: The IAM instance profile role [AWSRDSCus*******] is missing the following permissions...
I change the premissions on IAM, i create the new VPC,Security groups with custom adresses with tutorial from AWS, and still i have the same problem,
Basic RDS with the same VPC, work without trouble.

Someone have the same problem?

Answer

I have faced similar issues when creating RDS Custom for SQL Server. The best way to resolve this is to follow the recommended approach of using a CloudFormation template mention below.

You can compare your existing setup to the template and identify what setting and steps may be missing or incorrect related to your VPC, IAM, and instance profile configuration during RDS Custom database creation. By aligning to the reference CloudFormation template, you are more likely to set up the required networking, permissions, roles and other dependencies properly for a successful RDS Custom deployment. You can also use following YouTube videos for your reference to create a RDS custom instance.

1. Configure networking, instance profile, and encryption: "Configuring with AWS CloudFormation (recommended)"
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/custom-setup-sqlserver.html#custom-setup-sqlserver.iam-vpc

2. How to Create and Connect to RDS Custom for SQL Server Instance : 
https://www.youtube.com/watch?v=6rJArhGNens

3. Troubleshooting DB issues for Amazon RDS Custom for SQL Server: 
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/custom-troubleshooting-sqlserver.html

RDS custom - Incompatible-create

Relevant content