Connecting to AWS RDS Microsoft SQL Server with Multi-AZ (Always On) DB configuration and MultiSubnetFailover parameter in connection string fails.

Question

Hello. I'm using AWS RDS Microsoft SQL Server with Multi-AZ (Always On) configuration and sqlcmd tool to connect to DB. But when I use 'MultiSubnetFailover' parameter in the connection string I get error:
"Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Connecting to a mirrored SQL Server instance using the MultiSubnetFailover connection option is not supported.."
My sqlcmd connection string is "sqlcmd -I -W -C -M -b -m-1 -d "
Does anyone have any ideas why this happens when using the 'MultiSubnetFailover parameter?
Would be grateful for any ideas and suggestions. Thanks in advance.

Accepted Answer

Hi,

Please check https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_SQLServerMultiAZ.html
It states that:
```
Amazon RDS exposes the Always On AGs availability group listener endpoint. The endpoint is visible in the console, and is returned by the DescribeDBInstances API operation as an entry in the endpoints field.
```

Connecting to AWS RDS Microsoft SQL Server with Multi-AZ (Always On) DB configuration and MultiSubnetFailover parameter in connection string fails.

Contenuto pertinente