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 / Finance | Project Operations, Human Resources, ... / Point Microsoft Gp app...
Finance | Project Operations, Human Resources, ...
Answered

Point Microsoft Gp application to existing database.

(0) ShareShare
ReportReport
Posted on by Satyajit Bhapkar 50

Hello Team, 

Good Morning.

My system gets crash because of a hardware issue. I am having a backup of the Gp database on one drive.

Previously Gp was installed on that system and it was working fine. Due to a system crash, I have installed GP on the new system. In the installation process,

I pointed out the existing database in the ODBC Data Source. After the installation, it creates a system database and sample company database. Not point to the existing database.

My main question was How would I point the GP application to an existing database. Is that any setting or configuration should I have to do to achieve this result.

Kindly so suggest me. So that Gp runs from an existing database, not from the new database.

Thanks and Regards,

Satyajit Bhapkar.

I have the same question (0)
  • Verified answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at

    In the Dex.ini of the GP directory, there is a line such as this:

    Pathname=DYNAMICS/dbo/

    This is what tells the GP code when you launch it, what system database to look for, then it uses the SY01500 table to know what company databases it has.

    The ODBC DSN itself, used to connect GP to SQL should not have a database specified, per KB 870416.

    Thanks

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 14,095 Most Valuable Professional on at

    Please note that if you change the ODBC DSN to the new server address, only 'sa' will work to login.

    All the other users will fail as their encrypted passwords will no longer work because the encryption algorithm includes the DSN in its calculations.

    See: winthropdc.wordpress.com/.../

    Regards

    David

    PS: GP Power Tools Database Validation can be used to recreate all the users with generated passwords and email the users their temporary password so they can change them on next login.

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 664 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 522 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans