ESB Toolkit installation: OLE DB error

When you try to install the ESB toolkit BAM definition file Microsoft.BizTalk.ESB.BAM.Exceptions.xml you might encounter this error OLE DB error: OLE DB or ODBC error: Cannot open database “BAMStarSchema” 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_ExcByApplication’, Name of ‘bam_ExcB yApplication’. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of ‘ExcByApplication_ExcFaultDescription’, Name of ‘ExcByApplication_ExcFa ultDescription’ was being processed. Errors in the OLAP storage engine: An error occurred while the ‘FaultDescription’ attribute of the ‘ExcByApplication_ExcFaultDescription’ dimension from the ‘BA MAnalysis’ database was being processed. Server: The operation has been cancelled. The main reason for the exception is, the SQL Server service account must have read access to BAMStarSchema database. In my case it was configured to run under Network Service account. To fix this issue, open SQL server management studio, expand BAMStarSchema, Security, User. Right-click and select New User and configure it as shown below SNAGHTML1206b00b