AWS RDS Custom SQL Server Incompatible-create
I have created a RDS Custom SQL Server instance. But after waiting for a long time, the status of instance change to 'Incompaible-create'. And there is one record in the Recent event: 'You can't create the DB instance because of incompatible resources. Workflow step ValidateInstanceProfile reached timeout: 600 seconds'. How can I fix this error status? Thx
I have encountered similar situations while creating RDS Custom for Oracle. I found starting/restarting the base ec2 instances clearing up this problem usually. I would hence suggest you check the status of the base ec2 instances.
Thanks Govardhanan, but when the RDS Custom status change to Incompaible-create, I can`t find the EC2 instance which is created by RDS Custom anymore...
There are few areas to check on this issue:
Follow official doc to make sure your VPC and IAM created per requirements. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/custom-setup-sqlserver.html#custom-setup-sqlserver.review
Select correct VPC , Subnet Group and instance profile during the DB Creation
- Check security group, if Security Group used by RDS is not same as default security groups (the one associated with VPC endpoints), make sure necessary file ports open
Relevant questions
AWS RDS Custom SQL Server Incompatible-create
asked 6 months agoRDS SQL Server - scaling up down instance size
Accepted Answerasked 2 years agoGeneral questions regarding RDS SQL Server Read Replicas
Accepted Answerasked 2 years agoRDS SQL Server upgrade downtime
Accepted Answerasked 2 years agoRDS for SQL. List of supported system_procedures
asked 2 months agoAnnouncement: Amazon RDS for SQL Server ending support for Microsoft SQL Server 2012
asked a month agoSQL Server BYOL option missing
Accepted Answerasked 4 years agoRDS Sql Server support for 15.0.4198.2
asked 2 months agoIs it possible to use AWS RDS SQL Server as an AAG target from on premise primary?
asked 7 months agoUpdate instance type of EC2 running SQL server
Accepted Answer
And there is an AccessDenied error in CloudTrial, event name is PutTargets Error Message is : User: arn:aws:sts::xxxxxxxxx:assumed-role/AWSServiceRoleForRDSCustom/SLRManagement is not authorized to perform: events:PutTargets on resource: arn:aws:events:us-east-2:xxxxxxxxx:rule/do-not-delete-rds-custom-db-KXBOWMDX2LBPGHYDTJQHC7PJD4-xxxxxx because no identity-based policy allows the events:PutTargets action. Is it the root cause for this issue?