Microsoft KB Archive/870604

= You receive a &quot;Failed to create Management database&quot; error message when you install BizTalk Server 2004 on a computer that is running SQL Server 2000 =

Article ID: 870604

Article Last Modified on 1/7/2005

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft BizTalk Server 2004 Developer Edition
 * Microsoft BizTalk Server 2004 Enterprise Edition
 * Microsoft BizTalk Server 2004 Partner Edition
 * Microsoft BizTalk Server 2004 Standard Edition

-





SYMPTOMS
When you install Microsoft BizTalk Server 2004 and then you run the Configuration Wizard, you may receive the following error message:

&quot;Failed to create Management database &quot;BizTalkMgmtDb&quot; on server &quot; &quot;.

Invalid column name 'productminor'.

SQL script file: &quot; :\Program Files\Microsoft BizTalk Server 2004\Schema\\BTS_Version_Logic.sql&quot;

SQL command batch: &quot;CREATE PROCEDURE [dbo].[adm_Query_BizTalkDBVersion]

@BizTalkDBName nvarchar(64)

…&quot;



CAUSE
This problem may occur if you change the following settings in Microsoft SQL Server 2000 before you install BizTalk Server 2004:
 * You change the Collation designator option from the default setting to Latin1_General.
 * You change the sort order from the default setting to Case-sensitive (CS) and Accent-sensitive (AS).

Note After you install BizTalk Server 2004, you can change the settings for the Collation designator option and for the sort order back to what you want.



RESOLUTION
To resolve this problem, rebuild the master database. Use the default settings for the Collation designator option and for the sort order. Then, install BizTalk Server 2004. To do this, follow these steps:  Remove BizTalk Server 2004.

Note To remove BizTalk Server 2004, search for Removing the BizTalk Server Configuration in the Microsoft BizTalk Server 2004 Help file. In SQL Server 2000, change the settings for the Collation designator option and for the sort order back to the default settings. Rebuild the master database.

Important When you rebuild the master database, you will lose previously created databases.

To rebuild the master database, follow these steps:  Exit SQL Server 2000. Then, run the Rebuild Master utility (Rebuildm.exe). This utility is located in the following folder:



 In the Rebuild Master dialog box, click Browse. In the Browse for Folder dialog box, select the Data folder where SQL Server 2000 is installed. Then, click OK.</li> Click Settings. Then, in the Collation Settings dialog box, verify that the default settings are selected.

Note By default, when you run the Rebuild Master utility, the default settings are selected.</li> In the Rebuild Master dialog box, click Rebuild to start the process.</li></ol> </li> Install BizTalk Server 2004.</li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

<div class="references_section">