Microsoft KB Archive/888265

= How to move Microsoft Provisioning Server (MPS) databases to a clustered virtual SQL Server 2000 named instance =

Article ID: 888265

Article Last Modified on 4/17/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft Provisioning System

-





IN THIS TASK

 * INTRODUCTION
 * Assess your environment
 * Prepare the servers
 * Move the customer database (HECustomerDB)
 * Move the MPS databases
 * REFERENCES



INTRODUCTION
This article describes how to migrate your Microsoft Provisioning Server (MPS) databases from a stand-alone Microsoft SQL Server 2000 instance to a clustered virtual SQL Server 2000 named instance.

back to the top



Assess your environment
These instructions assume that you have prepared the cluster servers and that you have a working MPS server. For example, your environment may be similar to the following:
 * One cluster that is named CluCar with 2 nodes that are named dlg1 and dlg2
 * One virtual SQL Server 2000 named instance of VSQL1\INST1
 * One MPS server that is installed on a default instance of SQL Server 2000. This MPS server is named MPS01
 * All the following MPS databases are installed on the default SQL Server 2000 instance on the MPS server:
 * MPFConfig
 * MPFAudit
 * MPFTranLogData
 * HECustomerDB

When you have the completed the migration that is described in this article, your environment will be similar to the following:
 * The MPS service and the Provisioning Engine Microsoft COM+ application are running on the MPS server (MPS01).
 * All MPS databases are running on the clustered virtual SQL Server 2000 named instance.

back to the top

Prepare the servers
To help with the migration, copy the Service Provisioning folder from the Hosted Exchange 2003 CD to a local hard disk drive that is on the MPS server. Hosted Exchange 2003 is one of the Microsoft Solutions for Microsoft Windows-based Hosting. Additionally, copy this folder to the two SQL Server 2000 clustered nodes. In this article, you must run the Mpf.msi command from the \Service Provisioning\MPS 1.0\MPF\Standard folder.

back to the top

Move the customer database (HECustomerDB)
  Paste the following code in an XML editor or Notepad:   

 If the Provisioning Engine COM+ application is running on this node, restart the application.  Log on to the second clustered node (dlg2), and then follow these steps:  Rerun the Mpf.msi command and only change the value of the Config Server Name property to VSQL1\INST1.

Note The following registry entry will be updated:

</li> If the Provisioning Engine COM+ application is running on this node, restart the application.</li></ol> </li> Log on to the MPS server (MPS01), and then follow these steps:  Rerun the Mpf.msi command and only modify the value of the Config Server Name property to VSQL1\INST1.

Note The following registry entry will be updated:

</li> Restart the MPS service and the Provisioning Engine COM+ application.</li></ol> </li></ol>

Note When a SQL Server 2000 failover occurs, you must restart the Provisioning Queue Manager service.

back to the top

<div class="references_section">