Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Installing GP on Separ...
Microsoft Dynamics GP (Archived)

Installing GP on Separate Database and Application Servers

(0) ShareShare
ReportReport
Posted on by Devin 1,797

I know that MS recommends installing the GP databases on a dedicated database server.  I believe though that most businesses install the GP application (server client) on the database server as well.  Our production control group would like us to completely separate the database from the application and put the two on separate servers.  It appears that this can be accomplished through the ODBC connection established during the initial setup.  I would like to ask if there are any downsides to doing this.  Also, would installing any of the following on the "application server" (separate from the database server) pose any problems?

  • Integration Manager
  • FRx
  • Forecaster
  • Greenshades
  • Advanced HR/Payroll

Would this cause issues for Business Portal?

*This post is locked for comments

  • zelleay Profile Picture
    zelleay 115 on at
    Re: Installing GP on Separate Database and Application Servers

    I have not experienced any problems related to this except you have to make sure that Folders in application server should have full user access for all users.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Installing GP on Separate Database and Application Servers

    Hi Devin,

    There are no issues with not having a local install of GP on the database server. We have many customers who have just MSSQL running on a dedicated server with no install of the Dynamics GP installation files. Additionally, we have instances of the Business Portal application running on its own dedicated server. There should be no issues eithre with FRx or Forecaster. I can't vouch for Greenshades or HR/Payroll, although I can't see why there would be any issues with eithre application not being installed on the database server.

    The fact that an ODBC can be created during the install isn't that relevant to your query above, since you can create an ODBC yourself (ie you can install the application files without asking the install to set up an ODBC...and add one yourself later). If you need help setting up an ODBC, post here again.

    Hope this helps.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,399 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans