Hi,
I tried query an mssql instance I have in rds with the following command:
aws rds-data execute-sql --db-cluster-or-instance-arn "arn:aws:rds:eu-west-1:******1:db:devtest-********-01-rds-db" --database "Js" --aws-secret-store-arn "arn:aws:secretsmanager:$(aws-region):$(aws-account-id):secret:${{ parameters.cluster }}-51WqBM" --sql-statements "SELECT 1"
or
aws rds-data execute-statement --resource-arn "arn:aws:rds:$(aws-region):$(aws-account-id):db:${{ parameters.cluster }}-rds-db" --database "J******s" --secret-arn "arn:aws:secretsmanager:$(aws-region):$aws-account-id):secret:${{ parameters.cluster }}-51WqBM" --sql "SELECT 1"
but I take always the following:
An error occurred (BadRequestException) when calling the ExecuteStatement operation: Invalid cluster arn:
ARN and secret has been check and they are correct.
I suspect this is coming up because is not an Aurora SQL.
Anyone has a suggestion please?
Hi, thanks a lot for your prompt answer. Is any way to query an mssql instance from my azure pipelines?