Does Active Roles support Multi-AZ deployment for Amazon RDS? (4379848)

Does Active Roles support Multi-AZ deployment for Amazon RDS?

Currently, Active Roles does not support Multi-AZ deployment for Amazon RDS due to Amazon allows the @@SERVERNAME  and SERVERPROPERTY('servername') be different.

Active Roles is hardcoded to make sure the server identity must match across all SQL name-related functions, if it falls outside this rule, the configuration is considered invalid and an error is seen on the Configuration Center when trying to configure the RDS instance.

"Invalid SQL Server computer name. Use the short computer name to specify the SQL Server instance, such as "computername" or "computername\instancename".
@@servername: EC2AMAZ-46JLHQT
serverproperty('servername'): EC2AMAZ-11PVDP2
SQL Server instance specified: <fqdn of the RDS instance, 1433>"

An enhancement request 498857 has been created detailing the feature above.

WORKAROUND

Fix the mismatch using sp_dropserver/sp_addserver.

"EXEC sp_dropserver 'EC2AMAZ-46JLHQT';
EXEC sp_addserver 'EC2AMAZ-11PVDP2', 'local';"

Please be aware the SQL query may need to be executed in case a failover happens on Amazon.

STATUS

The product team will evaluate the request and this feature may become available in a future release of the product. Please refer to this article for updates or contact support referencing the Enhancement Request ID: 498857.