Database Login Accounts

 

BizTalk Server creates SQL login groups, and maps them to the SQL Server Roles and Database Roles listed in the following table:

Group

Description

SQL Server Roles or Database Roles

BizTalk Application Users

Includes all accounts with access to In-Process BizTalk hosts (hosts processes in BizTalk Server, BTSNTSvc.exe). Use one BizTalk Host Group for each In-Process host in your environment.

BTS_HOST_USERS SQL Server Database Role in the following databases:

BizTalkMgmtDb

BizTalkMsgBoxDb

BizTalkRuleEngineDb

BizTalkDTADb

BAMPrimaryImport

BAM_EVENT_WRITER SQL Server Database Role in the BAMPrimaryImport

BizTalk Isolated Host Users

Includes all accounts with access to the Isolated BizTalk hosts. Use one BizTalk Isolated Host Group for each Isolated Host in your environment.

BTS_HOST_USERS SQL Server Database Role in the following databases:

BizTalkMgmtDb

BizTalkMsgBoxDb

BizTalkRuleEngineDb

BizTalkDTADb

BAMPrimaryImport

BizTalk Server Administrators

Includes all BizTalk Server Administrators that will deploy solutions, manage applications and resolve message processing issues.

BTS_ADMIN_USERS SQL Server Database Role in the following databases:

BizTalkMgmtDb

BizTalkMsgBoxDb

BizTalkRuleEngineDb

BizTalkDTADb

BAMPrimaryImport

db_owner SQL Server Database Role for the following databases:

BAMStarSchema

BAMPrimaryImport

BAMArchive

BAMAlertsApplication

BAMAlertsNSMain

NSAdmin SQL Server Database Role in the following databases:

BAMAlertsApplication

BAMAlertsNSMain

BizTalkDTADb

BizTalkMgmtDb

OLAP Administrators on the computer hosting the BAMAnalysis OLAP database.

BizTalk Server Operators

Has a low privilege role with access only to monitoring and troubleshooting actions

Contains no service accounts

BTS_OPERATORS SQL Server Database Role in the following databases:

BizTalkDTADb

BizTalkMgmtDb

BizTalkMsgBoxDb

BizTalkRuleEngineDb

SSO Administrators

Top-level administrators of the Enterprise Single Sign-On (SSO) service.

Contains user account used to run BizTalk Configuration must be in this group.

Contains Enterprise Single Sign-On Service account and any users/groups that need to be able to configure and administer BizTalk Server and SSO.

db_owner SQL Server Database Role for the SSO

securityadmin SQL Server Role for the SQL Server where SSO is located

BizTalk Server creates SQL login accounts, and maps them to the SQL Server Database Roles as the following table:

User Account

Description

SQL Database Roles

Rule Engine Update Service

User account used to the Rule Engine Update Service.

RE_HOST_USERS SQL Server Database Role in the BizTalkRuleEngineDb

BAM Notification Services User

User account used to the BAM Notification Services.

NSRunService SQL Server Database Role in the following databases:

BAMAlertsApplication

BAMAlertsNSMain

BAM_ManagementNSReader SQL Server Database role for the BAMPrimaryImport

BAM Management Web Service user

User account used to the BAM Management Web Service.

NSSubscriberAdmin SQL Server Database Role in the following databases:

BAMAlertsApplication

BAMAlertsNSMain

BAM_ManagementWS SQL Server Database role for the BAMPrimaryImport

Community Additions

Show: