Currently Prisma doesn't support the MultiSubnetFailover option of SQL Server. See prisma/prisma#9187. I think this would require support at the driver level so I'm adding an issue here.

Other info: https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql/sqlclient-support-for-high-availability-disaster-recovery