•  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.

By Neha S

Leave a Reply

Your email address will not be published.