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