Microsoft KB Archive/918110

= Error message when you try to upgrade to Microsoft Dynamics CRM 3.0: &quot;Microsoft CRM 3.0 server setup did not complete successfully&quot; =

Article ID: 918110

Article Last Modified on 8/8/2006

-

APPLIES TO


 * Microsoft Dynamics CRM 3.0

-





SYMPTOMS
When you try to upgrade from Microsoft CRM 1.2 to Microsoft Dynamics CRM 3.0, you may receive the following error message:

Microsoft CRM 3.0 server setup did not complete successfully.

Additionally, you may find the following error message in the setup log:

Action Microsoft.Crm.Setup.Server.InstallDatabaseAction failed.

The Snapshot Agent corresponding to the publication ' _METABASE' could not be dropped. Could not drop the publication.

The Snapshot Agent corresponding to the publication ' _MSCRM' could not be dropped. Could not drop the publication.

Note In the setup log error message,  represents the actual organization name.



CAUSE
This problem occurs because the Microsoft CRM 3.0 setup process cannot drop the replication that is used for the MSCRM and METABASE databases.



RESOLUTION
To resolve this problem, follow these steps:  Uninstall Microsoft CRM 3.0, and then restore the Microsoft CRM 1.2 database. To do this, follow these steps:  See the following article in the Microsoft Knowledge Base:

915094 How to roll back an upgrade from Microsoft Business Solutions CRM 1.2 to Microsoft Dynamics CRM 3.0

 Complete the following sections of the article:  &quot;How to uninstall the Microsoft CRM 3.0 binary components&quot; &quot;How to roll back the Microsoft CRM databases to Microsoft CRM 1.2&quot; </li></ol>

Note You do not have to reinstall Microsoft CRM 1.2.</li> Enable publishing. To do this, use one of the following methods.

Method 1

If Microsoft CRM Deployment Manager is still installed, follow these steps: <ol style="list-style-type: lower-alpha;"> Log on to the Microsoft CRM server as a Microsoft CRM System Administrator user.</li> Click Start, point to Programs, point to Microsoft CRM, and then click Deployment Manager.</li> In Deployment Manager, click Server Manager, right-click the name of the Microsoft CRM server, and then click Configure SQL Server.</li> Click the instance of Microsoft SQL Server in the SQL Server list, click Next, and then click Finish.</li></ol>

Note If you cannot enable publishing by using Deployment Manager, follow the steps in method 2.

Method 2

If Microsoft CRM Deployment Manager is unavailable, follow these steps: <ol style="list-style-type: lower-alpha;"> Log on to the instance of Microsoft SQL Server as a SQL Server administrator user.</li> Click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.</li> In the Connect to SQL Server dialog box, click the instance of Microsoft SQL Server in the SQL Server list, and then click OK.</li> Click the  _MSCRM database in the list of databases.

Note  represents the actual organization name.</li>  Run the following script in SQL Query Analyzer. EXEC p_CRMReplicationSetup '<SQL Server name>', '<SQL Server name>', '<Microsoft CRM MSCRM database name>', '<Microsoft CRM METABASE database name>', '<Replication SQL Server directory>', '<SQL logon group name>', '<Microsoft CRM MSCRMDistribution database name>' Notes  In the script,  represents the actual SQL Server name.</li> In the script,  represents the actual MSCRM database name. This name has the following format:

_MSCRM

</li> In the script,  represents the actual METABASE database name. This name has the following format:

_METABASE

</li>  represents the actual organization name.</li> In the script,  represents the path of the Repldata directory on the SQL server. By default, this path is the following path:

C:\Program Files\Microsoft SQL Server\Mssql\Repldata

</li> <li>In the script,  represents the actual SQL logon group name. This name has the following format:

\SQLRepl { }

Note  represents the actual domain name. represents an actual GUID. For example, the GUID could be the following string:

E5334FB9-440A-4BD8-A19A-0FA54E6B248C

To find the SQL logon group name, follow these steps: <ol> <li>On the computer that is running Microsoft SQL Server, click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.</li> <li>In Enterprise Manager, expand Microsoft SQL Servers, expand SQL Server Group, expand the instance of the server where Microsoft CRM was installed, expand Security, and then click Logins.</li> <li>Right-click  \SQLRepl { }, and then click Properties.</li> <li>In the Properties dialog box, click the Database Access tab.</li> <li>The SQL logon group names are the names in the User column. You can use one of these names.</li></ol> </li> <li>In the script,  represents the distribution database name. This name that has the following format:

_MSCRMDistribution

Notes <ul> <li>If you do not see this database in SQL server, specify the database name as _MSCRMDistribution.</li> <li> represents the actual organization name.</li></ul> </li></ul> </li></ol> </li> <li>Verify that the replication components were created. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>Log on to the SQL server as a SQL Server administrator user.</li> <li>Click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.</li> <li>In Enterprise Manager, expand Microsoft SQL Servers, expand SQL Server Group, expand the instance where Microsoft CRM was installed, and then expand Replication Monitor.</li> <li>Expand Publishers, and then expand the SQL server.

Note You can find two publishers. One has the prefix CRMMetaPub, and the other has the prefix CRMPub.</li> <li>Click CRMMetaPub, right-click Snapshot, and then click Start Agent.</li> <li>Click CRMPub, right-click Snapshot, and then click Start Agent.

Notes <ul> <li>The snapshot publications may take from five to ten minutes to finish.</li> <li>After the CRMMetaPub snapshot is completed, you receive the following message:

A snapshot of 79 article(s) was generated.

</li> <li>After the CRMPub snapshot is completed, you receive the following message:

A snapshot of 93 article(s) was generated.

</li></ul> </li> <li>Verify that the schedule for the snapshot jobs was deleted. To do this, follow these steps: <ol> <li>Right-click the CRMMetaPub snapshot, and then click Agent Properties.</li> <li>In the Agent dialog box, click the Schedule tab.</li> <li>Highlight all listed jobs, click Delete, and then click OK.</li> <li>Repeat steps g1 through g3 for the CRMPub snapshot agent.</li></ol> </li></ol> </li> <li>In Enterprise Manager, right-click Replication, click Disable Publishing and Distribution, and then follow the instructions that appear on the screen to disable the replication.</li> <li>Delete the ASReplicationObjects table from the MSCRM and METABASE databases.</li> <li>Repeat step 3.</li> <li>Upgrade Microsoft CRM 3.0 again.</li></ol>

Keywords: kbtshoot kbmbsupgrade kberrmsg kbmbsmigrate kbprb KB918110

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.