web
You’re offline. This is a read only version of the page.
close
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

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    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.

  • zelleay Profile Picture
    zelleay 115 on at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans