OLE DB or ODBC error: Login failed for user–Deploying BAM Activities

Posted: July 27, 2016  |  Categories: General Uncategorized

After you have setup a new BizTalk server and start deploying BAM Activities, in this case Microsoft.BizTalk.ESB.BAM.Exceptions.xml which has a Cube that needs to be deployed into the BAM OLAP Database, you can get this error:

SNAGHTML5f71fb9

To fix this error, you need to find the logon that was trying to access the BAMStarSchema database, in this case ‘NT SERVICE\MSSQLServerOLAPService’ (this is the default account for OLAP in the SQL Install)

Add ‘NT Service\MSSQLServerOLAPService’ as a SQL Logon

SNAGHTML5f64e11

Give this account db_datareader for the BAMStarSchema database

SNAGHTML5f83d7e

Re-Run the BAM Deploy

SNAGHTML5f9ed9f

Problem Fixed

One Platform Operations, Monitoring and Analytics Software
BizTalk360

microsoft biztalk

Learn more

Over 500 customers across 30+ countries depend on BizTalk360

ServiceBus360

Azure service bus

Learn more

Start managing your Azure Service Bus namespaces in minutes

One Platform - Operations, Monitoring and Analytics Software
BizTalk360

microsoft biztalk

Learn more

Over 500 customers across 30+ countries depend on BizTalk360

One Platform - Operations, Monitoring and Analytics Software
ServiceBus360

Azure service bus

Learn more

Start managing your Azure Service Bus namespaces in minutes

Back to Top