Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP Local Install - Res...
Microsoft Dynamics GP (Archived)

GP Local Install - Restore Database

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

Dear All,

I have installed GP 2013 R2 in my local machine and I have SQL server 2008 R2 local again.  I have created 2 new companies in this GP.  Copied a back up file from the live SQL server and restored over one of the database which is created locally and ran the SQL script  to update the COMPANYID and INTERID in the test database.  I am getting the following error while logging in even though after pressing 2 ok I am in GP and able to go to all windows.  Not sure will this cause any issues can anyone guide me to fix this error.  I have already ran the utilities twice.

*This post is locked for comments

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... on at
    RE: GP Local Install - Restore Database

    Dear All,

    Thats worked fine and thanks for all your input.  One last question when I logged into GP there are 2 little window open on minimise mode and I cant get that maximised and not sure why thats pops up.  Also I wanted to know does any of you have experience to install Dynamics NAV on the same machine which installed GP on it.

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: GP Local Install - Restore Database

    Babu, uninstalling SQL, or any app for that matter, usually leaves behind some files.  I think you can resolve this by following the path in the error message and delete any folders left behind after the de-install.

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... on at
    RE: GP Local Install - Restore Database

    Hi Richard & Ian,

    Hi Richard and Ian,

    I have removed SQL and GP fully and re-installed SQL with the above collation.  After this I have installed GP and when I press the installation its ask for whether I wanted on install dexterity I press yes then it went to the installation menu where I selected Dynamics GP.  The Installation went fine and after that I ran GP Utilities and got the following error.

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... on at
    RE: GP Local Install - Restore Database

    Thanks Richard and Ian for your valuable suggestions, let me do this and let you know my update.

  • Verified answer
    Ian Grieve Profile Picture
    Ian Grieve 22,782 on at
    RE: GP Local Install - Restore Database

    Latin1_General_CI_AS is the default collation of SQL Server, but is not one of the two collations GP supports. The most common collation used is SQL_Latin1_General_CP1_CI_AS.

    It is always advisable to confirm the collation of the source SQL Server before installing a new instance to ensure you have the same collation on the new server.

    As Richard says, you will need to uninstall SQL Server from your local machine and reinstall after confirming the collation on the source system.

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GP Local Install - Restore Database

    The collation sequence of SQL is different than of the collation sequence of your databases. Did you select something other than the default collation sequence when you installed SQL? GP will work with case sensitive (50) or case insensitive (52). Case insensitive is the default.

    http://technet.microsoft.com/en-us/library/aa176552(v=sql.80).aspx

    Check out this list for a complete listing of collation sequences. Your best bet right now is to detach your databases, uninstall SQL and reinstall SQL with the correct collation sequence.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans