Monday, March 17, 2014

ERROR: Failed to set up BAM database(s). The specified account is already in the view.

We have had this error occur when installing BAM Alerts.

It's a pain which was caused by another part of BAM not working, and leaving bits left over......

Solution is simple enough:

SQL Server Management Console
 BAMPrimaryImportDB
  Security
   Roles
    DatabaseReoles
     BAM_ManagementNSReader
        Remove the account here.

Remove the BAMAlerts Database.

Try again.