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
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?
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
AWS RDS Custom SQL Server Incompatible-createasked 6 months ago
RDS SQL Server - scaling up down instance sizeAccepted Answerasked 2 years ago
General questions regarding RDS SQL Server Read ReplicasAccepted Answerasked 2 years ago
RDS SQL Server upgrade downtimeAccepted Answerasked 2 years ago
RDS for SQL. List of supported system_proceduresasked 2 months ago
Announcement: Amazon RDS for SQL Server ending support for Microsoft SQL Server 2012asked a month ago
SQL Server BYOL option missingAccepted Answerasked 4 years ago
RDS Sql Server support for 15.0.4198.2asked 2 months ago
Is it possible to use AWS RDS SQL Server as an AAG target from on premise primary?asked 7 months ago
Update instance type of EC2 running SQL serverAccepted AnswerMODERATORasked 3 years ago