Microsoft KB Archive/829206

= PRB: BizTalk Server 2002 Setup Cannot Join an Existing Group That Is Running BizTalk Server 2002 Service Pack 1 =

Article ID: 829206

Article Last Modified on 9/22/2006

-

APPLIES TO


 * Microsoft BizTalk Server 2002 Standard Edition

-



SYMPTOMS
If you install Microsoft BizTalk Server 2002, and then you select the option to join an existing BizTalk Server group that is running Microsoft BizTalk Server 2002 Service Pack 1 (SP1), the database setup does not succeed. When this behavior occurs, you receive errors messages that are similar to the following in the BizTalk Server application log:

Event Type:   Error Event Source:  MsiInstaller Event Category: None Event ID:  11722 Date:      9/17/2003 Time:      5:46:05 PM User:       N/A Computer:  BIZTALKSERVER Description: Product: Microsoft BizTalk Server 2002 -- Error 1722. There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor. Action Launch_BTSsetupDB, location: C:\Program Files\Microsoft BizTalk Server\Setup\BTSsetupDB.exe, command: &quot;C:\Program Files\Microsoft BizTalk Server\Setup\&quot; &quot;&quot;

For more information, see Help and Support Center at http://support.microsoft.com. Data: 0000: 7b 31 32 42 37 44 30 39  {12B7D09 0008: 41 2d 39 32 41 42 2d 34  A-92AB-4 0010: 35 39 36 2d 39 39 36 36  596-9966 0018: 2d 37 30 37 39 39 38 33  -7079983 0020: 37 44 39 36 31 7d        7D961}

-and-

Event Type: Warning Event Source:  Application Event Category: None Event ID:  0 Date:      9/17/2003 Time:      5:28:35 PM User:       N/A Computer:  BIZTALKSERVER Description: The description for Event ID ( 0 ) in Source ( Application ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: An error occurred while attempting to select the BizTalk Messaging Management database. The specified SQL server might not be running or the server name might be incorrect.

Hresult: 0x80004005 Description: [DBNETLIB][ConnectionOpen (ParseConnectParams).]Invalid connection. SQL Error 14: 08001 Source: Microsoft OLE DB Provider for SQL Server.



CAUSE
This behavior occurs because changes are made to the database schema during setup of BizTalk Server 2002 SP1 that are not compatible with BizTalk Server 2002 for the database setup process.



WORKAROUND
To work around this behavior, use either of the following methods:

Method 1
 Install BizTalk Server 2002 without running the database configuration part of the setup. To do this, run the following command at a command prompt:

msiexec /I &quot; &quot; BTSSETUPDB=0 XLANGSETUPDB=0

Note Make sure that the path and the name of the Windows Installer (.msi) file are enclosed in quotation marks. When the Setup wizard starts, click to clear the check box for the option to start the BizTalk Messaging Service. After you have installed BizTalk Server 2002, install BizTalk Server 2002 SP1. You may receive error messages that state that the setup could not patch the database and cannot continue. Ignore these error messages and finish the setup of BizTalk Server SP1. When the setup of BizTalk Server SP1 has completed, verify that the BizTalk Server Messaging service is stopped. Locate and then run the BtsSetupDB.exe executable file. This file is located in the Microsoft BizTalk Server\Setup folder. When you receive the prompt, specify the databases for the BizTalk Server group that you want to join, and then continue the wizard.</li> When you receive the prompt, click the existing BizTalk Server group, and then finish the wizard.</li> Locate and then run the XLANGsetupDB.exe executable file. This file is located in the Microsoft BizTalk Server\setup folder.</li> When you receive the prompt, specify the XLANG database for the BizTalk Server group that you want to join, and then finish the wizard.</li></ol>

Method 2
<ol> Install BizTalk Server 2002. Click to select the option to create new databases.</li> Install BizTalk Server 2002 SP1.</li> In BizTalk Server Administrator, stop BizTalk Server 2002 SP1.</li> In BizTalk Server Administrator, remove the computer where you installed BizTalk Server 2002 SP1 in step 2 from the group that it belongs to.</li> Start BizTalk Server Administrator on a computer that is running BizTalk Server that belongs to the group that you want to join.</li> Add the computer where you installed BizTalk Server 2002 SP1 in step 2 to the group that you want to join. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> Right-click the group that you want to join, point to New, and then click Server.</li> Type the name of the computer where you installed BizTalk Server 2002 SP1 in step 2, and then click OK.</li></ol> </li></ol>

<div class="status_section">

STATUS
This behavior is by design.

Keywords: kbprb KB829206

-

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

© Microsoft Corporation. All rights reserved.