Dynamics GP On-Prem Automatic Failover SQL Implementation

  • Dynamics GP On-Prem Automatic Failover SQL Implementation

    Posted by Rebecca Siegler on September 11, 2024 at 10:40 am

    We are standing up SQL 2022 servers and want to implement full automatic failover. There are some areas we already know are potential gotchas such as synchronization GP SQL Users logins and passwords, SQL jobs and Management Reporter. Has anyone implemented automatic failover successfully for GP 18 modern lifecycle and have some tips/tricks/guidelines? Are there specific sql components that need to be implemented to synchronize users and passwords to avoid having to reset passwords every time it fails over? Is there a particular method that SQL Jobs need to be stood up to continue to run only on the primary server after failover? What needs to happen to keep Management Reporter healthy after a failover?

    Thanks!

    David Morinello replied 3 weeks, 4 days ago 2 Members · 1 Reply
  • 1 Reply
  • David Morinello

    Member
    September 11, 2024 at 5:25 pm
    Up
    0
    Down
    ::

    That sounds like a fun challenge.

    I’d start with Alias’ for the SQL Servers. GPPT has some cool features for passwords if necessary, but I have always wanted to try SQL Alias for a scenario like this.

Log in to reply.

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!