I have the following question:
I would like to deploy the following configuration.
Independent RDS Broker servers with local DBs (SQL express type will work):
• Single DNS label with round robin to 4 Broker servers.
• Each Broker will be placed in a different Hyper-V server.
• Each Broker will have their own local SQL express database.
• Each broker independently to provide access to all the RDSH servers.
Can this be configured? I know that if the broker goes down the users will initiate new session since the DB is not shared and it is local. I am also aware that I can configure HA between brokers using a shared DB.
I am just trying to explore the other scenario since I don't have a reliable SQL cluster available.