Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Having 2nd Instance of...
Microsoft Dynamics GP (Archived)

Having 2nd Instance of Dynamics on same SQL Server

(0) ShareShare
ReportReport
Posted on by babubaskaran@outloo... 10

Hi All,

We have 2 GP site one in Europe and one in USA.  We are planning to move one of the company from Europe into USA server.  Since both has different dynamics and products, we are planning to have a 2nd instance on same SQL server and install new client with separate Dynamics instance and copy the Dynamics & company database and restore it on new instance.  So the USA server will have old dynamics and its own companies and 2nd new Dynamics2 and one new company which is copied from server in Europe.  My question is whether we can use the same GP License key for the 2nd new Dynamics Instance for the new company.

*This post is locked for comments

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Having 2nd Instance of Dynamics on same SQL Server

    Hi Babu,

    I'm working since a few months on a similar customer project where 2 different GP instances need to be merged. One being on GP 2010 and the other on 2015.

    Fortunately they used the out-of-the-box currencies, thus they are sharing the same currency indexes and I had not to run scripts to adjust for those.

    However, I had to write SQL scripts to populate the missing FX rates from the GP 2015 instance, as they were using MC transactions in that instance for about 3-4 different currencies, whereas the GP 2010 was only in native currency (CAD).

    PM me know if you want more details.

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 10 on at
    RE: Having 2nd Instance of Dynamics on same SQL Server

    Hi Thanks for your kind reply.

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 10 on at
    RE: Having 2nd Instance of Dynamics on same SQL Server

    Hi Steve,

    Thanks for your email.  The reason for having different Dynamics is both Dynamics has different set of currency using multi currency.  So currency index on one Dynamics is different to currency index on another Dynamics so I cannot copy the existing company into the other Dynamics directly.

  • kdd281 Profile Picture
    kdd281 469 on at
    RE: Having 2nd Instance of Dynamics on same SQL Server

    The license key is tied to the primary company name and user count. If you create another SQL Instance, then you would need to purchase another company license with there own user count. 

  • Steve Hoffort Profile Picture
    Steve Hoffort 97 on at
    RE: Having 2nd Instance of Dynamics on same SQL Server

    Babu - it is rare that you would need a different instance of GP.  What I have seen in the past is unique DYNAMICS.SET files which load the software.  I have worked with a client with 165 concurrent users where some companies have access to Canadian Payroll & WennSoft (Key2Act) while others have US Payroll and Project Accounting.  They still used the same instance of SQL, but users called up a unique DYNAMICS.SET file to load the appropriate software for the companies the user maintained.

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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans