On my new virtual machine BizTalk Server and all features are installed, including Business Activity Monitoring. But somehow some security settings are not set correctly. To solve this problem I made the service account DBO on the BAMPrimaryImport database, that did the job.
So, what was happening. While deploying it is using some service and it is not using my own account. I receive the next message in the EventLog (MSSQLServerOLAPService):
OLE DB error: OLE DB or ODBC error: The SELECT permission was denied on the object ‘bam_RegNonHL7MsgVw_ChangeToHL7Progress_RTATable’, database ‘BAMPrimaryImport’, schema ‘dbo’.; 42000.
and (BamManagementUtility):
Microsoft.BizTalk.Bam.Management.BamManagerException: The BAM deployment failed. —> Microsoft.AnalysisServices.OperationException: OLE DB error: OLE DB or ODBC error: The SELECT permission was denied on the object ‘bam_RegNonHL7MsgVw_ChangeToHL7Progress_RTATable’, database ‘BAMPrimaryImport’, schema ‘dbo’.; 42000.
Server: The operation has been cancelled.at Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadResponse(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfError)
at Microsoft.AnalysisServices.AnalysisServicesClient.Process(IMajorObject obj, ProcessType type, Binding source, ErrorConfiguration errorConfig, WriteBackTableCreation writebackOption, ImpactDetailCollection impact)
at Microsoft.AnalysisServices.Server.Process(IMajorObject obj, ProcessType processType, Binding source, ErrorConfiguration errorConfig, WriteBackTableCreation writebackOption, XmlaWarningCollection warnings, ImpactDetailCollection impactResult, Boolean analyzeImpactOnly)
at Microsoft.AnalysisServices.Server.SendProcess(IMajorObject obj, ProcessType processType, Binding source, ErrorConfiguration errorConfig, WriteBackTableCreation writebackOption, XmlaWarningCollection warnings, ImpactDetailCollection impactResult, Boolean analyzeImpactOnly)
at Microsoft.AnalysisServices.ProcessableMajorObject.Process(ProcessType processType, ErrorConfiguration errorConfiguration, XmlaWarningCollection warnings)
at Microsoft.AnalysisServices.ProcessableMajorObject.Process(ProcessType processType)
at Microsoft.BizTalk.Bam.Management.Olap2008Helper.CreateRtaCubes(Database db, XmlNode cubeNode)
at Microsoft.BizTalk.Bam.Management.Olap2008Helper.CreateOlapInfrastructure(Boolean realTimeOnly)
at Microsoft.BizTalk.Bam.Management.Olap2008Helper.CreateOlapInfrastructure()
at Microsoft.BizTalk.Bam.Management.ViewModule.Create(XmlDocument defXmlDoc)
at Microsoft.BizTalk.Bam.Management.WorkerModule.DispatchOperation(OperationType operation, XmlDocument defXmlDoc)
at Microsoft.BizTalk.Bam.Management.BamManager.ProcessOneBamArtifactType(BamArtifactType bamArtifact, OperationType operation)
at Microsoft.BizTalk.Bam.Management.BamManager.ManageInfrastructure(OperationType operation)
at Microsoft.BizTalk.Bam.Management.BamManager.Deploy()
— End of inner exception stack trace —
at Microsoft.BizTalk.Bam.Management.BamManager.Deploy()
at Microsoft.BizTalk.Bam.Management.BamManagementUtility.BamManagementUtility.HandleDeployAll()
at Microsoft.BizTalk.Bam.Management.BamManagementUtility.BamManagementUtility.DispatchCommand()
at Microsoft.BizTalk.Bam.Management.BamManagementUtility.BamManagementUtility.Run()
at Microsoft.BizTalk.Bam.Management.BamManagementUtility.BamManagementUtility.Main(String[] args)
Did I gave too much access to this service account? Or what access level should I set for the Service Account in SQL Server on the BAMPrimaryImport?
