SYMPTOMS
When you start Microsoft Dynamics GP or Microsoft Business Solutions - Great Plains, you may receive the following error message: Dynamics SQL Database has not been setup for this version.
CAUSE
Cause 1
This problem occurs because the values in the tables in the DYNAMICS database do not correspond to the version of Microsoft Dynamics GP or of Microsoft Business Solutions - Great Plains that you are using. See Resolution 1 in the "Resolution" section.
Cause 2
This problem occurs because the Client installation of Microsoft Dynamics GP was installed instead of the Server installation. You must install the Server installation before you can update the databases in Utilities. See Resolution 2 in the "Resolution" section.
RESOLUTION
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
| • |
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
| • |
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
| • |
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
If you are using Microsoft Dynamics GP, remove the Client installation and reinstall the Server installation. To do this, follow these steps:
| 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
If you are using Microsoft Business Solutions - Great Plains, convert the Client installation to a Server installation. To do this, follow these steps:
| 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:
| a. |
At the Select to Install Server or Client window, click Server and Client Installation. |
| b. |
At the Select Great Plains Components window, click SQL Server Objects. | |
| 3. |
Finish the installation. |