0

I have created an Aurora Serverless V2 Cluster with one reader and one writer Instance via CDK.

Now I am trying to enable Babelfish for this cluster by adding a parameter group:

const auroraParameterGroup = new rds.ParameterGroup(this, "AuroraParameterGroup", {
  engine: rds.DatabaseClusterEngine.auroraPostgres({
    version: rds.AuroraPostgresEngineVersion.VER_15_2
  }),
  parameters: {
    "rds.babelfish_status": "on"
  }
})

The AWS RDS Consule UI says that Babelfish is turned on and listening on port 1433.

But when I try to connect to the DB with the MSSQL Server Management Studio, I get this error message: MS MSM Connect Error

This is the Aurora CDK Code:

const auroraCluster = new rds.DatabaseCluster(this, 'AuroraCluster', {
  parameterGroup: auroraParameterGroup,
  engine: rds.DatabaseClusterEngine.auroraPostgres({
    version: rds.AuroraPostgresEngineVersion.VER_15_2
  }),
  storageEncryptionKey: rdsKey,
  instances: 2,
  credentials: rds.Credentials.fromSecret(auroraCredentials),
  instanceProps: {
    enablePerformanceInsights: true,
    publiclyAccessible: true,
    vpc: props.vpc,
    vpcSubnets: props.vpc.selectSubnets({ subnetGroupName: props.databaseSubnetGroupName }),
    instanceType: new InstanceType('serverless'),

  },
});

auroraCluster.connections.allowFromAnyIpv4(aws_ec2.Port.tcp(5432))
auroraCluster.connections.allowFromAnyIpv4(aws_ec2.Port.tcp(1433)) //babelfish

When I create the Aurora DB with Babelfish manually via the AWS Management Console, the connection works.

thoroc
  • 3,291
  • 2
  • 27
  • 34
Vincent Elbracht
  • 1
  • 1
  • It would probably be better to put the error in plain text instead of having a linked image. For anyone else reading this the error message is: "Login failed for "aurorauser" (Microsoft SQL Server, Fehler: 18456)" – thoroc Jun 27 '23 at 08:30

0 Answers0