You receive a "Failed to create Management database" error message when you install BizTalk Server 2004 on a computer that is running SQL Server 2000 (870604)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
  • 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:
"Failed to create Management database "BizTalkMgmtDb" on server "YourBizTalkServer".
Invalid column name 'productminor'.
SQL script file: "Drive:\Program Files\Microsoft BizTalk Server 2004\Schema\\BTS_Version_Logic.sql"
SQL command batch: "CREATE PROCEDURE [dbo].[adm_Query_BizTalkDBVersion]
@BizTalkDBName nvarchar(64)
."

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:
  1. 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.
  2. In SQL Server 2000, change the settings for the Collation designator option and for the sort order back to the default settings.
  3. 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:
    1. Exit SQL Server 2000. Then, run the Rebuild Master utility (Rebuildm.exe). This utility is located in the following folder:

      Drive:\Program Files\Microsoft SQL Server\80\Tools\Binn

    2. In the Rebuild Master dialog box, click Browse.
    3. In the Browse for Folder dialog box, select the Data folder where SQL Server 2000 is installed. Then, click OK.
    4. 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.
    5. In the Rebuild Master dialog box, click Rebuild to start the process.
  4. Install BizTalk Server 2004.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

REFERENCES

For more information about BizTalk Server 2004, visit the following Microsoft Web site:

http://www.microsoft.com/biztalk

For more information about SQL Server 2000, visit the following Microsoft Web site:

http://www.microsoft.com/sql

Modification Type:MajorLast Reviewed:1/7/2005
Keywords:kbinfo kbprb KB870604 kbAudEndUser kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.