370
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
Thanks guys. I will check all the options and get back to you.
Thanks once more.
Joegay.
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
This problem occurred on the client and not the server. can this solution suffice?
Thanks.
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.
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.
Backup your databases, uninstall 2005, install 2008, re-attach your databases, upgrade functionality to 2008 level
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (