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


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 <db_name>" Does anyone have any ideas why this happens when using the 'MultiSubnetFailover parameter? Would be grateful for any ideas and suggestions. Thanks in advance.

asked 9 months ago845 views
1 Answer
Accepted Answer


Please check 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.
profile picture
answered 9 months ago
profile picture
reviewed 2 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions