Problem
Configuration fails with an error similar to the following:
Failed to set up BAM database(s)
Cannot open database requested in login 'BAMPrimaryImport'
Logon fails. Logon failed for user 'BizTalk\BizTalkUser'
Cause
This error can occur if an .mdf file or an .ldf file already exists in the \MSSQL\data folder of the computer running SQL Server that has the same name as the .mdf file or the .ldf file that the BizTalk Server configuration program 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 configuration program with an .mdf and an .ldf extension appended.
Resolution
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.