You receive a "Login failed for user" error message when the BizTalk Server 2004 Configuration Wizard creates databases

When you run the Microsoft BizTalk Server 2004 Configuration Wizard and you choose the option to create a new BizTalk Server Group, you receive an error message that is similar to the following when the Configuration Wizard tries to create the databases that BizTalk Server will use:Note In the error message, BizTalk\BizTalkUser is a placeholder for the actual domain name and account name for the currently logged on user.

When you receive this error message, you may receive an error message that is similar to the following in SQL Profiler if you run a Profiler trace against the Microsoft SQL Server where the BizTalk Server 2004 Configuration Wizard is installing the BizTalk Server databases:

This behavior occurs if an .mdf file or an .ldf file already exists in the \Program Files\Microsoft SQL Server\MSSQL\data folder of your SQL Server that has the same name as the .mdf file or the .ldf file that the BizTalk Server 2004 Configuration Wizard is trying to create. The names of the .mdf file and the .ldf file that are created for the databases are derived from the name of the database that is specified in the BizTalk Server 2004 Configuration Wizard with an .mdf and an .ldf extension appended.

To resolve this behavior, use one of the following methods:

• Delete any .mdf files or .ldf files that have names that match the names of any databases that you are creating.
• Choose database names that do not match the names of any .mdf files or .ldf files that already exist in the \Program Files\Microsoft SQL Server\MSSQL\data folder of your SQL Server.

This behavior is by design.

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