Microsoft Dynamics GP

Forums

Home » Microsoft Dynamics GP » Microsoft Dynamics GP Forum
Related Search Results

The stored procedure getDBName() of form duSQLInstall Pass Throught SQL returned the following results: DBMS: 58, Microsoft Dynamics GP:0.

by
on 27 Mar 2012
  • Not Answered

DBMS: 515 Error message

by
on 15 Oct 2009
  • Suggested Answer

Error DBMS 10054

by
on 5 Mar 2013
  • Not Answered

Installation error: The stored procedure verify/versionInformation of form duSQLInstallPass through SQL returned the following results: DBMS: 468 Microsoft Dynamics GP:0

This question is not answered
Trudy Emmrich
Posted by
on 23 Feb 2012 11:14 AM

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.
All Replies
  • Thông D.
    Posted by
    on 23 Feb 2012 2:29 PM

    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?
  • Trudy Emmrich
    Posted by
    on 23 Feb 2012 8:15 PM

    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
  • Thông D.
    Posted by
    on 23 Feb 2012 8:18 PM

    Did you right-click on Dynamic Utilities and select Run As Administrator?
  • Trudy Emmrich
    Posted by
    on 24 Feb 2012 2:05 PM

    yes, got the same error. it happens right away.
  • Thông D.
    Posted by
    on 24 Feb 2012 2:52 PM

    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.

  • Jason Lech
    Posted by
    on 27 Feb 2012 2:19 PM

    Trudy,

    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:

    sp_helpsort

    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.
  • Jason Lech
    Posted by
    on 28 Feb 2012 8:18 AM

    Trudy,

    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