Announcements
I have a customer running GP 2013 using native password encryption. They are concerned about GP and SQL high availability. What options are available? What if they want to take advantage of SQL FCI or Availability Groups? Is this possible?
I've never tested it in a Clustered environment, but technically yes.
See this post to get the details: community.dynamics.com/.../dynamics-gp-on-a-cluster-environment
The first link in the above post is broken and here is the correct one :
support.microsoft.com/.../description-of-the-requirements-to-run-replication-clustering-log-ship
This community post has an official response from Microsoft :
community.dynamics.com/.../high-availability-with-gp-2016
Hope this helps.
Thanks Beat.
So are you saying it is possible to get an FCI to work? Generally SQL clusters are accessed via the "listner" name which is defined in DNS for the exact purpose you mention. Is this what you are referring to?
Hi
Microsoft has posted once a document about this topic and Dynamics GP doesn't support HA for SQL servers.. you can use transaction log shipping, but that's about it.
If you do a search on the internet, you should be able to find the related papers about it I guess.
Reason why this isn't supported lies within the way the user pwd is encrypted on the SQL server side from the GP client. It is based on the server's instance name in the ODBC entry. Using another server with a different name would possibly fail authentication for all users, except 'sa'.
One way I had solved this problem was to use a DNS 'Alias' entry for the GP SQL server.. (i.e. DYNAMICSGP).
This way if you ever had to switch from one SQL server to the other, the name would remain identical and the passwords would still work. This requires careful planning, but works fine.
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156