Hi everyone,
When I try to create SQL server RDS with Microsoft SQL Server Windows Authentication setting:
I receive the error below:
When I look at Directory Service in eu-central-2, I also see 3 application and services avaiable for Directory:
Compare with eu-central-1, it seems to lack "Amazon RDS for SQL Server".
I also attached the log when I try to attach Directory Service to the RDS instance in eu-central-2 region using the next command:
aws --profile <info> --region eu-central-2 rds modify-db-instance \
--db-instance-identifier <info> \
--domain <d-c...info> \
--domain-iam-role-name rds-directoryservice-access-role \
--apply-immediately
The log content:
2023-07-11 10:49:02,066 - MainThread - botocore.httpsession - DEBUG - Certificate path: /usr/local/aws-cli/v2/2.12.3/dist/awscli/botocore/cacert.pem
2023-07-11 10:49:02,066 - MainThread - urllib3.connectionpool - DEBUG - Resetting dropped connection: rds.eu-central-2.amazonaws.com
2023-07-11 10:49:02,868 - MainThread - urllib3.connectionpool - DEBUG - https://rds.eu-central-2.amazonaws.com:443 "POST / HTTP/1.1" 500 324
2023-07-11 10:49:02,868 - MainThread - botocore.parsers - DEBUG - Response headers: {'x-amzn-RequestId': 'd0388f19-aa75-4c2b-adfa-0c9927c50b64', 'Strict-Transport-Security': 'max-age=31536000', 'Content-Type': 'text/xml', 'Content-Length': '324', 'Date': 'Tue, 11 Jul 2023 07:49:01 GMT', 'Connection': 'close'}
2023-07-11 10:49:02,869 - MainThread - botocore.parsers - DEBUG - Response body:
b'<ErrorResponse xmlns="http://rds.amazonaws.com/doc/2014-10-31/">\n <Error>\n <Type>Receiver</Type>\n <Code>InternalFailure</Code>\n <Message>An internal error has occurred. Please try your query again at a later time.</Message>\n </Error>\n <RequestId>d0388f19-aa75-4c2b-adfa-0c9927c50b64</RequestId>\n</ErrorResponse>\n'
2023-07-11 10:49:02,869 - MainThread - botocore.hooks - DEBUG - Event needs-retry.rds.ModifyDBInstance: calling handler <bound method RetryHandler.needs_retry of <botocore.retries.standard.RetryHandler object at 0x7fc1ed91f790>>
2023-07-11 10:49:02,869 - MainThread - botocore.retries.standard - DEBUG - Max attempts of 3 reached.
2023-07-11 10:49:02,870 - MainThread - botocore.retries.standard - DEBUG - Not retrying request.
2023-07-11 10:49:02,870 - MainThread - botocore.hooks - DEBUG - Event after-call.rds.ModifyDBInstance: calling handler <bound method RetryQuotaChecker.release_retry_quota of <botocore.retries.standard.RetryQuotaChecker object at 0x7fc1ed91f150>>
2023-07-11 10:49:02,873 - MainThread - awscli.clidriver - DEBUG - Exception caught in main()
Traceback (most recent call last):
File "awscli/clidriver.py", line 460, in main
File "awscli/clidriver.py", line 595, in __call__
File "awscli/clidriver.py", line 798, in __call__
File "awscli/clidriver.py", line 929, in invoke
File "awscli/clidriver.py", line 941, in _make_client_call
File "awscli/botocore/client.py", line 341, in _api_call
File "awscli/botocore/client.py", line 697, in _make_api_call
botocore.exceptions.ClientError: An error occurred (InternalFailure) when calling the ModifyDBInstance operation (reached max retries: 2): An internal error has occurred. Please try your query again at a later time.
An error occurred (InternalFailure) when calling the ModifyDBInstance operation (reached max retries: 2): An internal error has occurred. Please try your query again at a later time.
Is there anything I can do to make it work?
Thank you for your help. I will create support ticket first for checking.