While setting up a test server I received the error above in Dynamics Utilities. I verified versions of SQL and Dynamics with our production server. Had copied company and Dynamics database from production to test server. Did before and it was ok. Started on a new test server, now I'm stuck.
I'm confused about your "test server" and "new test server". What Windows version are running on those "servers"?. Most errors that generated when you run Dynamics Utilities are from not running with elevated-privileges account. If I assume your platform are Windows 2008 and Windows 7, did you try DU with Run As Administrator?
I've set up a test server with Windows Server 2008 logged in as Administrator. I'm running Dynamics Utilities under sa. I'm setting up a test environment for the GP upgrade from 9.0 to 2010. I've set up a test server before but the hard drive crashed and had to start over again. I was successful to move the production environment to the test environment before... but now I'm getting this version error. I'm only working on this test server.
thanks for your reply
Did you right-click on Dynamic Utilities and select Run As Administrator?
yes, got the same error. it happens right away.
Did you "copy" or restore the databases to the new test server? Look for the KB of "Moving GP databases to new server" and follow them. It should work.
The issue you are listing has been documented in KB 943966.
If you log into CustomerSource, you will be able to review this document.
In a nutshell, the collation of the GP databases is not the same as the collation of the test server's System database.
You will want to run the following statement on the test server as well as on your production GP SQL Server:
You will likely see them as different.
You will then need to remove and reinstall that SQL Instance to match the collation of yoru production GP SQL Server.
Let me know if you have any questions.
I was wondering if you had the opportunity to go through KB 943966 to correct the issue.
Let me know if you have any additional questions
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13