BizTalk 2013: Unexpected exception occurred while configuring BAM Portal

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

 

Cause:
=======
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