Symptoms
When you try to create a new company in Microsoft Dynamics GP, you receive the following error message:
Install of database databaseName failed! Microsoft Dynamics GP Utilities will now shut down.
When you click OK, you return to the Additional Tasks window. When you start Microsoft Dynamics GP, the new company does not appear in the list of available companies. However, the new company database appears in Microsoft SQL Server.
Cause
This problem occurs if you specify a reserved SQL Server keyword as the Company ID of the new company. The reserved SQL Server keywords include the following keywords:
-
CROSS
-
GRANT
-
ALL
-
UPDATE
-
FROM
-
SET
The reserved SQL Server keywords are not supported as company IDs in Microsoft Dynamics GP. To identify whether a word is a reserved SQL Server keyword, type that word in a query window in SQL Server 2005 Management Studio or in a query window in Query Analyzer. If the word becomes dimmed, or if the word becomes blue, the word is a SQL Server keyword. If the word remains black, you can use it as a valid company ID in Microsoft Dynamics GP.
Resolution
To resolve this problem, remove the company database together with its reference to the company ID that is not valid. Then, re-create the company. To do this, follow these steps.
SQL Server 2005
-
On the computer that is running SQL Server 2005, click Start, point to Programs, point to Microsoft SQL Server 2005, click SQL Server Management Studio, and then connect to the instance of SQL Server on which the Microsoft Dynamics GP databases are located.
-
Expand Databases, and then locate the new company database that you created. For example, locate CROSS.
-
Right-click the company database, and then click Delete.
-
In the Delete Object window, click OK.
-
In the SQL Server Management Studio window, click New Query.
-
To remove the reference to the company ID that is not valid, type the following statement, and then click Execute.
delete DYNAMICS..DB_Upgrade where db_name = 'DatabaseName'Note In this statement, replace DatabaseName with the name of the affected database. For example, replace DatabaseName with CROSS.
-
Start Microsoft Dynamics GP Utilities, and then create a new company. In the Company ID box, type a company ID that is not a reserved SQL Server keyword.
SQL Server 2000
-
On the computer that is running SQL Server 2000, start Enterprise Manager.
-
Expand Microsoft SQL Servers, expand SQL Server Group, expand the instance of SQL Server on which the Microsoft Dynamics GP databases are located, expand Databases, and then locate the new company database that you created. For example, locate CROSS.
-
Right-click the company database, and then click Delete.
-
Click Yes to confirm the removal of the database.
-
Start Query Analyzer, and then connect to the instance of SQL Server on which the Microsoft Dynamics GP databases are located.
-
To remove the reference to the company ID that is not valid, type the following statement, and then press F5.
delete DYNAMICS..DB_Upgrade where db_name = 'DatabaseName'Note In this statement, replace DatabaseName with the name of the affected database. For example, replace DatabaseName with CROSS.
-
Start Microsoft Dynamics GP Utilities, and then create a new company. In the Company ID box, type a company ID that is not a reserved SQL Server keyword.
