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) / Point existing GP Busi...
Microsoft Dynamics GP (Archived)

Point existing GP Business Portal to a new server with the Back Office GP database but different server name.

(0) ShareShare
ReportReport
Posted on by TSMurphy 372

Scenario is we have two servers:

  • One that is configured with GP 2010 and GP Web Services installed (GPSRV1 is the server name).  
  • The other server (GPBP1 is the server name) just has GP Business Portal 5.1 running under SharePoint 2010 Foundation pointing to GPSRV1.

GPSRV1 has encountered some potential serious issues but still running in production, so we are quickly configuring a new server (GPSRV2 is the server name) in order to transition relatively soon.  The problem encountered is how to point the GP Business Portal back office connection to point to the new server.

Point GP Business Portal connection on GPBP1 to the new server GPSRV2.

We have crawled through the files on GPBP1 looking for a connection string we could possibly modify but haven't found anything.  Reviewed the official GP documentation, searched the GP Customer Source and internet but came up with nothing.  

The only option we have came up with is to uninstall GP Business Portal and re-install and point it to the new back office connection that has the new server name.  Trying to avoid this option due to the major customizations we have built out within the GP Business Portal to fit the business.

Any help would be very much appreciated.

Thanks in advance,

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Rob Bernhardt Profile Picture
    Rob Bernhardt on at

    Timothy,

    Take a look at the config files located in your root and root/bin SharePoint directories on the BP server.  One or multiple should hold information about the GP connection.

    Thanks

    Rob

  • Verified answer
    TSMurphy Profile Picture
    TSMurphy 372 on at

    Changed the server name and datasource in the following files.

    • C:\inetpub\wwwroot\web.config
    • C:\inetpub\wwwroot\bin\BusinessFramework.config
    • C:\inetpub\wwwroot\bin\~privatefile.dbauthentication.config

    Plus a registry change at Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Business Portal\Install

    • Server Name
    • ServiceMachine

    ** Note for those who attempt.  May have to copy out the config files to the desktop, modify the file and copy/replace back into the folder location due to UAC binding on the files.

    ** Note:  Be aware of what new server to point where references database and GP Web Services.

  • TSMurphy Profile Picture
    TSMurphy 372 on at

    Change GP Business Portal to point to a new DB server

    Modify install registry key:

    HKLM\Software\Microsoft\Business Portal\Install

    ServerName

    ServiceMachine

    For the next three files, you'll need to move the files to the desktop, make the changes

    then paste them back into the folder.

    In c:\inetpub\ftproot\web.config, change DynamicsGPWCFService address:

    <client>

         <endpoint name="DynamicsGPWCFService" address="http://<servername>:48620/Dynamics/GPService/GPService" binding="wsHttpBinding" bindingConfiguration="DynamicsGPWCFService" contract="Microsoft.Dynamics.GP.Proxy.WCF.DynamicsGP">

           <identity>

             <servicePrincipalName value="" />

           </identity>

         </endpoint>

       </client>

    and GP Server, and GP WebServiceURL, and GPWCFServiceURL

     <appSettings>

       <add key="DynamicsGPServer" value="<servername\sql instance>" />

       <add key="DynamicsGPWebServiceURL" value="http://<servername>:48620/DynamicsGPWebServices/DynamicsGPService.asmx" />

       <add key="DynamicsGPWCFServiceURL" value="http://<servername>:48620/Dynamics/GPService/GPService" />

       <add key="containmentProvider" value="Microsoft.Dynamics.GP.BusinessPortal.Containment.BusinessFrameworkContainment, Microsoft.Dynamics.GP.BusinessPortal.Containment" />

       <add key="containmentChangerMBF" value="Microsoft.Dynamics.GP.BusinessPortal.Containment.BusinessFrameworkContainment, Microsoft.Dynamics.GP.BusinessPortal.Containment" />

       <add key="containmentChangerSP" value="Microsoft.Dynamics.GP.BusinessPortal.Containment.SharePointContainment, Microsoft.Dynamics.GP.BusinessPortal.Containment" />

     </appSettings>

    in c:\inetpub\wwwroot\bin\~privatefile.dbauthentication, modify the server name under <name>

    <server>

       <name><servername\sql instance></name>

    in c:\inetpub\wwwroot\bin\BusinessFramework.config, modify the DataLocationPolicyConfig

    <Microsoft.Dynamics.DataLocationPolicyConfig>

       <databaseServer type="String" value="<servername\sql instance>"/>

       <databaseName type="String" value="DYNAMICS"/>

    </Microsoft.Dynamics.DataLocationPolicyConfig>

    Don’t forget to change the datasources in Reporting Services to point to new server for GP reports and graphs.

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
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans