Configuration fails if a SQL Server database file that has the same name as the specified database already exists in the SQL Server data folder - Enterprise Integration Server - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - Premier - Standard - external - Standard - Premier

Enterprise Integration Server

Platform
OnBase
Product
Enterprise Integration Server
Release
Foundation 23.1
License
Standard
Premier

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.