You receive an error message when the Validating Product Version Information process is run in Microsoft Dynamics GP Utilities

Symptoms
When the Validating Product Version Information process is run in Microsoft Dynamics GP Utilities, you receive the following error message:
The stored procedure verifyVersionInformation() of form duSQLInstall Pass Through SQL returned the following results: DBMS: 468, Microsoft Dynamics GP: 0.
Cause
This problem occurs if the collations and the sort orders of the DYNAMICS database and of the company database do not match the collations and the sort orders of the Microsoft SQL Server system databases.

To compare the collations and the sort orders of the databases, see the "More Information" section.
Resolution
To resolve this problem, correct the collations and the sort orders so that they are the same for the DYNAMICS database, for the company database, and for the SQL Server system databases. To do this, use one of the following methods.

Method 1

Contact your partner of record or Microsoft Advisory Services for information about a billable service to correct the collations and the sort orders. To do this, use of of the following options, depending on whether you are a partner or a customer.

Customers:
For more information about services to correct the collations and the sort orders, contact your partner of record. If you do not have a partner of record, visit the following web site to identify a partner: Microsoft Pinpoint.

Partners:
For more information about services to correct the collations and the sort orders, contact Microsoft Advisory Services at 800-MPN-SOLVE or via email at askpts@microsoft.com

Method 2

Change the collations and the sort orders of the DYNAMICS database and of the company database by using the Bulk Copy Process (BCP) feature of SQL Server.

For more information about scripts when you use the BCP process to change the SQL Server sort order, click the following article number to view the article in the Microsoft Knowledge Base:
875179 How to use the Bulk Copy Process (BCP) to export Microsoft Dynamics GP data from one database and import data into a new database

Note For more information about consulting services to change the SQL Server sort order, contact your partner of record or Microsoft Advisory Services, depending on whether you are a customer or a partner. 

Customers:
For more information about consulting services, contact your partner of record If you do not have a partner of record, visit the following web site to identify a partner: Microsoft Pinpoint.

Partners:
For more information about consulting services, contact Microsoft Advisory Services at 800-MPN-SOLVE or via email at askpts@microsoft.com

Method 3

If this issue occurs after moving Microsoft Dynamics GP to a new server, uninstall SQL Server and reinstall SQL Server choosing the same sort order as your previous server was using. To determine the correct sort order, see the “More Information” section.
More information
The SQL Server system databases can be the following databases:
  • master
  • model
  • msdb
  • tempdb
To compare the collations and the sort orders of the databases, follow these steps:
  1. Run the sp_helpdb command in a query tool. To do this, use one of the following methods.

    Method 1: If you use SQL Server Management Studio
    1. Click Start, point to All Programs, point to Microsoft SQL Server 2005 or to Microsoft SQL Server 2008, and then click SQL Server Management Studio.
    2. In the "Connect to Server" window, follow these steps:
      1. In the Server name box, type the name of the server that is running SQL Server.
      2. In the Authentication box, click SQL Authentication.
      3. In the Login box, type sa.
      4. In the Password box, type the password for the sa user, and then click Connect.
    3. Click File, point to New, and then click Query with Current Connection.
    4. In the blank query window, type the following script.
      sp_helpdb
    5. On the Query menu, click Execute.
    Method 2: If you use SQL Query Analyzer
    1. Click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer.
    2. In the "Connect to SQL Server" window, follow these steps:
      1. In the SQL Server box, type the name of the old server that is running SQL Server.
      2. In the Connect using area, click SQL Server Authentication.
      3. In the Login name box, type sa.
      4. In the Password box, type the password for the sa user, and then click OK.
    3. In the blank query window, type the following script
      sp_helpdb
    4. On the Query menu, click Execute.
    Method 3: If you use Support Administrator Console
    1. Click Start, point to All Programs, point to Microsoft Support Administrator Console, and then click Support Administrator Console.
    2. In the "Connect to Server" window, follow these steps:
      1. In the SQL Server box, type the name of the new server that is running SQL Server.
      2. In the Login Name box, type sa.
      3. In the Password box, type the password for the sa user, and then click OK.
    3. In the blank query window, type the following script.
      sp_helpdb
    4. On the File menu, click Execute.
  2. To view the data, expand the Status column in the results.
  3. Compare the values after the following statements:
    Collation=
    SQLSortOrder=
    For example, you may see a statement that resembles the following statement.
    Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52
    Note The following SQL Server sort orders are supported by Microsoft Dynamics GP:
    • Binary Sort Order: 0 and 50
    • Dictionary Order Case-Insensitive (DOCI) Sort Order: 52
Properties

Article ID: 943966 - Last Review: 06/20/2016 14:49:00 - Revision: 6.0

Microsoft Dynamics GP 10.0, Microsoft Dynamics GP 9.0, Microsoft Dynamics GP 2010, System Manager

  • kbexpertisebeginner kbtshoot kbmbsmigrate kbprb kbexpertiseinter KB943966
Feedback