• Stephen W. Thomas
  • Azure Integration Gurus
BizTalkGurus
  • Home
  • Blogs
    • Stephen’s BizTalk and Integration Blog
    • BizTalk Community Blogs via Syndication
  • Forums
  • Downloads
  • Videos
  • Training
    • Online Training
    • Classroom Training
Select Page

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

by bchesnut | Jul 26, 2016 | BizTalk Community Blogs via Syndication | 0 comments

This post was originally published here

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:

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

Add ‘NT ServiceMSSQLServerOLAPService’ as a SQL Logon

 

Give this account db_datareader for the BAMStarSchema database

Re-Run the BAM Deploy

Problem Fixed

Comments are closed.

  • Facebook
  • Twitter
  • Google+
  • Gmail
  • LinkedIn

Submit a Comment Cancel reply

You must be logged in to post a comment.


Search this Site:


Recent Posts

  • Santa Claus SMSs Logic App
  • BizTalk Server FTP issue: The FTP server did not accept a FTP command for an unexpected reason.
  • Azure Function: Zip File
  • How to remove/unmark Mark of the Web (MOTW) files with PowerShell
  • Announcing Logic App Consumption Copilot

Tweets by AzureIntGurus

Recent Topics

  • Evaluating on the amount of items returned in a message
  • Send and Receive ports problem
  • How to config/costom a WS Security to SOAP header
  • Email attachments – POP3 adapter
  • Calling ASP page from Biztalk Orchestration

  • Home
  • Blogs
  • Forums
  • Downloads
  • Videos
  • Training
  • Facebook
  • Twitter
  • RSS
@BizTalkgurus.com