- Use the RDS console to force a reboot of the database instance so that the primary server becomes the master server again.
- The server running the .NET utilities is caching the DNS lookup on the database cluster address. Flush the DNS cache of the server and force the C# utilities to open new connections to the database.
- A.NET application will retain the IP address of a connection string until the host machine is rebooted.
- The NET utilities need to change the SQL Server endpoint in the connection strings to read from the secondary database server using a try/catch.
Subscribe to our mailing list and get interesting stuff and updates to your email inbox.