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) / upgrade from sql serve...
Microsoft Dynamics GP (Archived)

upgrade from sql server 2005 developer to sql 2008r2 standard edition

(0) ShareShare
ReportReport
Posted on by joegay 372

Hi All,

My Dynamics GP 2010 runs on sql server 2005 sp3 developer edition and now wish to upgrade to sql server 2008r2 standard edition. 

I get an error message which says i cannot upgrade because the version i am upgrading from is not supported.

Can any one tell me what to do?

Thanks.

Joegay.

*This post is locked for comments

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

    Backup your databases, uninstall 2005, install 2008, re-attach your databases, upgrade functionality to 2008 level

  • Community Member Profile Picture
    Community Member on at

    Thanks Carl. It worked. The only thing i did not do was upgrading the functionality to 2008 because I did not know how to go about that. I only ran GP utility on the server after attaching the 2005 database and that was it.

    The other I am facing is my GP runs on a 64bit server and client OS. When i try to run utility on the client, I get this error "An error occurred while using the BCP utility, Data was not correctly copied to the server. Please verify your ODBC settings and that BCP has been correctly installed. Microsoft Dynamics GP utility will now exit". Even when I ran the the Utiltiy as administrator it give the same error message.

    Did I do anything wrong.

    Please assist.

    Thanks.

  • Mick Egan Profile Picture
    Mick Egan 3,561 on at

    check the DYNSA is the database owner: run sp_changedbowner 'DYNSA' against each GP database.

    Run Utilities as administrator - right click on Utiltiies "Run As" administrator. Problem occurs on Windows Server2008.

  • Community Member Profile Picture
    Community Member on at

    This problem occurred on the client and not the server. can this solution suffice?

    Thanks.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at

    If you completely unistalled SQL after detaching the databases and then reinstalled SQL you would have lost all of your SQL logins. THe users will be on the DYNAMICS and company databases but not in SQL. You needed to run the Capture_Login scripts on the 2005 instanance and then the results on the 2008 instance. As far as the clients go, turn UAC off as per this article.

    mohdaoud.blogspot.com/.../error-occurred-while-using-bcp-utility_5043.html

  • Community Member Profile Picture
    Community Member on at

    Thanks guys. I will check all the options and get back to you.

    Thanks once more.

    Joegay.

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