I created a BAM Activity Definition in Excel 2007: SomeView.xml. This file can be deployed with BM like:
BM deploy-all -definitionfile:SomeView.xml
In the DOS-box I received the output:
Deploying Activity… Done.
Deploying View… ERROR: The BAM deployment failed.
OLE DB error: OLE DB or ODBC error: Cannot open database “BAMPrimaryImport" requested by the login. The login failed.; 42000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of ‘bam_rta_SomeView’, Name of ‘bam_rta_SomeView’.
Server: The operation has been cancelled.
On the Internet I couldn’t find this message in conjunction with the BAMPrimaryImport database. When looking in the EventLog I saw the next Informational message:
Login failed for user ‘mymachine\myserviceaccount’. Reason: Failed to open the explicitly specified database. [CLIENT: <named pipe>]
After adding this account to the BAMPrimaryImport database with the right access, it worked all fine:
Deploying Activity… Done.
Deploying View… Done.
Deploying Security… Done.
Did I missed something during installation, or is it because I used BizTalk Server 2009 Beta?
Trackbacks/Pingbacks