Dynamics GP on a Cluster Environment

This is something we get to hear frequently in various forums whether Dynamics GP supports a cluster environment. The answer is Yes. This is what the KB926490 suggests. Few tips to install Dynamics GP in Clustered environment based on my earlier experience of doing the same for an implementation.

  1. We can run Dynamics GP in a single-instance clustering environment and in multiple instance clustering provided there is one to one relationship in a SQL Server instance
  2. We can install Dynamics GP in an Active-passive cluster mode.
  3. Assume, we have two servers A and B. On Server A(Active node), Dynamics GP and SQL Server databases reside. Server B acts as passive node.
  4. SQL Server databases need to be kept in a common drive for both servers A and B
  5. On the Server B, there is no need to install Dynamics GP.
  6. While installing Dynamics GP 10 Server on Server A, the installation detects the common drive for both servers and automatically maps the system and company databases to the same drive
  7. Once can refer to this link that presents a step-by-step guide to install SQL Server on cluster mode. Remember this is necessary prior to Dynamics GP installation.
  8. Installing SQL Servers on Clustered environment means, it will guide you to install the actual SQL Server on Server A (in this example) while Server B will be installed with a virtual SQL Server.

Once the installation is done in the above manner, we can test the configuration by forcing a failover on Server A. There are certain questions as to whether we can do the  failover cluster over terminal Services. The answer to me is No when I refer to this KB294926.

Besides supporting Clustering environment, Dynamics GP also supports Replication, Log Shipping and Database Mirroring as per the KB926490.

Popular posts from this blog

Dynamics GP Fixed Assets GL Posting Batch Missing After Depreciation Run

Image
I got a call from a user who was seemingly worried about her monthly depreciation batch went missing from GL posting routine in the Dynamics GP Fixed Assets. I quickly took her desktop on Teamviewer Quick support and understood the problem she is facing. Let me explain the issue in detail before I tell you the solution. Dynamics GP Fixed Assets GL Posting Issue Issue The user ran the depreciation routine in Dynamics GP for November month through Dynamics GP | Financial | Routines | Depreciate All Assets. Till here, all was good. She then proceeded to FA GL posting routine. Dynamics GP | Financial | Routines | GL Posting. She could not find the batch in GL posting lookup. In other words, the monthly depreciation batch is not accessible for posting. She then ran the depreciation process again and this time when she went to GL posting window and tried processing, the system threw an error message as below There are no transactions matching these restrictions. ...
Read more

How to Enable and Disable Maintenance Mode in Dynamics 365 FO

Image
Maintenance mode in Dynamics 365 for Finance and Operations is required to be switched on for system administrators to make system changes that might affect system functionality. It is available for the safe use of the application. Only those users with Maintenance mode user role and system administrators roles can sign into the application till the time the mode is turned off. When the maintenance mode is switched off, there can't be changes made in certain areas of the system. Maintenance mode is required for activities such as activating financial dimensions, creating departments/cost centres, account structure activation and other system related functions. Enable and Disable Maintenance Mode  The easy way to enable and disable maintenance mode is using SQL query the D365 FO on premises is installed. Previously, Lifecycle services (LCS) used to have such an option for configuring the maintenance mode.  Maintenance mode can be changed from enabled to disabled ...
Read more