Removing a Host Group from a SQL Server Role

BizTalk Server grants the BizTalk Host Windows group privileges to run stored procedures in the Configuration database, MessageBox database, and Tracking database by means of Microsoft SQL Server™ role memberships.

Any host marked as "host tracking" no longer uses the BizTalk Host group. BizTalk Administration automatically removes the BizTalk Host group from the SQL Server roles for the Tracking database.

You must manually remove the BizTalk Host group from the SQL Server roles for the Configuration database and the MessageBox database. For information about the host tracking property, see Modifying Host Properties in the BizTalk Administration Console.

Note  You must be a SQL Server system administrator to remove users from a SQL Server role group.

To remove a BizTalk Host group from a SQL Server role

1. Click Start, point to All Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
2. In the console tree, expand Microsoft SQL Servers, expand SQL Server Group, expand the SQL Server where the BizTalk databases are, expand Databases, expand the Configuration database (default name is BizTalkMgmtDb), and then click Roles.
3. In the results pane, right-click BTS_HOST_USERS, and then click Properties.
4. In the Database Role Properties window, select the BizTalk Host group you want to remove, click Remove, and then click OK.
5. In the console tree, expand the MessageBox database (default name is BizTalkMsgBoxDb), and then click Roles.
6. In the results pane, right-click BTS_HOST_USERS, and then click Properties.
7. In the Database Role Properties window, select the BizTalk Host group you want to remove, click Remove, and then click OK.

See Also

Managing BizTalk Hosts and Host Instances

About Host Groups

Modifying Host Properties in the BizTalk Administration Console