BizTalk 2013: Unexpected exception occurred while configuring BAM Portal

When you configure BizTalk 2013 BAM Portal with SQL 2012, an "Unexpected exception occurred while configuring BAM Portal" error may occur as below:


The configuration tool is trying to add the BAM Management Web Service user to a database role called NSSubscriberAdmin, which doesn’t exist in the BAMAlertsApplication database of SQL 2012.


Work around:
Manually grant the user with BTS_SubscriberAdmin or dbo(not recommended for security concern) role should fix the error.


Best regards,

WenJun Zhang