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

View products that this article applies to.

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: "C:\Program Files\Microsoft BizTalk Server\Setup\" "" 

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.

↑ Back to the top

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.

↑ Back to the top

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 "Path and Name of the BizTalk Windows Installer File" 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.
When you receive the prompt, click the existing BizTalk Server group, and then finish the wizard.
Locate and then run the XLANGsetupDB.exe executable file. This file is located in the Microsoft BizTalk Server\setup folder.
When you receive the prompt, specify the XLANG database for the BizTalk Server group that you want to join, and then finish the wizard.

Method 2

Install BizTalk Server 2002. Click to select the option to create new databases.
Install BizTalk Server 2002 SP1.
In BizTalk Server Administrator, stop BizTalk Server 2002 SP1.
In BizTalk Server Administrator, remove the computer where you installed BizTalk Server 2002 SP1 in step 2 from the group that it belongs to.
Start BizTalk Server Administrator on a computer that is running BizTalk Server that belongs to the group that you want to join.
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:
1. Right-click the group that you want to join, point to New, and then click Server.
2. Type the name of the computer where you installed BizTalk Server 2002 SP1 in step 2, and then click OK.

↑ Back to the top