Microsoft KB Archive/874873

= Error message when you upgrade or reinstall Microsoft CRM to existing databases: &quot;Setup was unable to install Microsoft CRM Server&quot; =

Article ID: 874873

Article Last Modified on 11/15/2006

-

APPLIES TO


 * Microsoft CRM 1.2
 * Microsoft Business Solutions CRM 1.0

-



SYMPTOMS
When you upgrade or reinstall Microsoft CRM 1.2 or Microsoft Business Solutions - CRM 1.0 to existing databases, you receive the following error message:

Setup was unable to install Microsoft CRM Server.

Setup was unable to grant access to the Microsoft CRM databases.

Unknown error. (80040E37)



CAUSE
This error occurs if one of the following conditions is true:
 * A Microsoft SQL Server user who is not the database owner (dbo) owns a table in the Microsoft CRM databases.
 * The Organization Unit name uses the maximum string length.



RESOLUTION
To resolve this problem, use one of the following methods.

Method 1
Verify the table ownership in the _MSCRM database and the  _Metabase database. To do this, follow these steps:
 * 1) Click Start, point to All Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
 * 2) Expand Microsoft SQL Servers, expand SQL Server Group, expand the instance of SQL Server where the Microsoft CRM databases are stored, and then expand Databases.
 * 3) Expand  _Metabase database, and then click Tables.
 * 4) A list of tables is displayed. Verify that the dbo user is the owner of all the tables in this database.
 * 5) Expand  _MSCRM database, and then click Tables.
 * 6) A list of tables is displayed. Verify that the dbo user is the owner of all the tables in this database.

Note The dbo user must own any custom tables that you created in the Metabase database or in the MSCRM database. The reinstallation process verifies table ownership and grants access to the tables. This error occurs during reinstallation if a table in these databases is owned by a user who is not the dbo user.

Method 2
The database must be restored from a prior database before you try to upgrade or reinstall. Before you try to upgrade again, you must rename the tables that exceed the string length limit.

To do this, run the following query with the _Metabase database as the selected database in SQL Query Analyzer. To do this, follow these steps:  Start SQL Query Analyzer. Click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.  Run the following script. SELECT name FROM sysobjects WHERE len(name)>99 

If you have any tables that are identified in the results of the script, contact Microsoft Customer Support Services to obtain the steps to correct this problem. For a complete list of Microsoft Customer Support Services telephone numbers and information about support costs, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support

Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Customer Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.

