Error message when you start Microsoft Dynamics GP: "Dynamics SQL Database has not been setup for this version"

Resolution 1

1. Make sure that you have a good backup of the DYNAMICS database.
2. Use Query Analyzer or SQL Management Studio to run the following script against the DYNAMICS database.

    SELECT * FROM DYNAMICS..DU000020
   SELECT * FROM DYNAMICS..DB_Upgrade 

   Notes
   • In the results for the DU000020 table, verify that the values in the following columns correspond to the version of Microsoft Dynamics GP or of Microsoft Great Plains that you are using:
     • The versionMajor column
     • The versionMinor column
     For example, if you are using Microsoft Dynamics GP 9.0, you should see the following values:
     • The versionMajor column: 9
     • The versionMinor column: 0
   • In the DB_Upgrade table results, verify that the values in the following columns correspond to the version of Microsoft Dynamics GP or of Microsoft Great Plains that you are using:
     • The db_verMajor column
     • The db_verMinor column
     • The db_verOldMajor column
     • The db_verOldMinor column
     For example, if you are using Microsoft Dynamics GP 9.0, you should see the following values:
     • The db_verMajor column: 9
     • The db_verMinor column: 0
     • The db_verOldMajor column: 9
     • The db_verOldMinor column: 0
3. If the values in the columns that are listed in step 2 do not correspond to the version of Microsoft Dynamics GP that you are using, run the following scripts in Query Analyzer or in SQL Server Management Studio.

   Script 1

    
   update DYNAMICS..DU000020 
     set versionMajor = VERSIONMAJOR, versionMinor = VERSIONMINOR
     where companyID = COMPANYID
    

   Notes
   • Replace the VERSIONMAJOR placeholder and the VERSIONMINOR placeholder with the numbers of the version that you are currently using. For example, if you are using Microsoft Dynamics GP 9.0, the VERSIONMAJOR placeholder should be 9 and the VERSIONMINOR placeholder should be 0.
   • Replace the COMPANYID placeholder with the company ID of the company that has the incorrect version information. To determine the company ID, run the following statement.

      
     SELECT * FROM DYNAMICS..SY01500
      

   Script 2

    
   update DYNAMICS..DB_Upgrade 
     set db_verMajor = VERSIONMAJOR, db_verMinor = VERSIONMINOR
     where db_name = DATABASENAME
    

   Notes
   • Replace the VERSIONMAJOR placeholder and the VERSIONMINOR placeholder with the numbers of the version that you are currently using. For example, if you are using Microsoft Dynamics GP 9.0, the VERSIONMAJOR placeholder should be 9 and the VERSIONMINOR placeholder should be 0.
   • Replace the DATABASENAME placeholder with the name of the database for the company.

Resolution 2

Microsoft Dynamics GP

1. Click Start, click Control Panel, and then click Add or Remove Programs.
2. On the list, select Microsoft Dynamics GP, and then click Change.
3. Click Remove to remove the Client installation of Microsoft Dynamics GP.
4. When you reinstall Microsoft Dynamics GP, click Server in the Installation Type window, and then click Next.
5. Finish the installation.

Microsoft Business Solutions - Great Plains

1. Start the installation by using CD 1 of the Microsoft Business Solutions - Great Plains installation CD set. To do this, double-click the CDSetup.exe file.
2. Click Install Great Plains, and then accept the same default settings that you used for the Client installation except for the following settings:
   1. At the Select to Install Server or Client window, click Server and Client Installation.
   2. At the Select Great Plains Components window, click SQL Server Objects.
3. Finish the installation.

Resolution 3