I have been unable to get Acumatica 24.209.0013 to work with SQL mirroring. All of our db’s including Acumatica are mirrored correctly. With mirroring off, everything works as it should. My connection string has both the Failover Partner and Initial Catalog keys defined, but something somewhere is ignoring them because I get the error: “Use of key 'Failover Partner' requires the key 'Initial Catalog' to be present.” when Acumatica tries to connect to the database. Has anyone successfully gotten this to work?
Answer
SQL Database Mirroring
Best answer by jeremychristy
UPDATE: replacing DB Mirroring with an Always On Availability Group and Listener has resolved the issue by abstracting the failover/replication away from the way that Acumatica handles database connections.
UPDATE: replacing DB Mirroring with an Always On Availability Group and Listener has resolved the issue by abstracting the failover/replication away from the way that Acumatica handles database connections.
Thank you for sharing your solution with the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.