Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. 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

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

View products that this article applies to.

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)
�"

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

Status

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

↑ Back to the top

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

↑ Back to the top

Keywords: KB870604, kbprb, kbinfo

↑ Back to the top

Article Info
Article ID : 870604
Revision : 3
Created on : 1/7/2005
Published on : 1/7/2005
Exists online : False
Views : 296