Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

FIX: User cannot perform certain database-related operations in BizTalk Server 2013


View products that this article applies to.

Symptoms

Issue 1

Consider the following scenario:
  • A user performs an operation by using an application that sends a port list in Microsoft BizTalk Server 2013.
  • The application uses the Microsoft.BizTalk.ExplorerOM assembly or BizTalk Server Administration Console.
  • The user is a member of the BTS_HOST_USERS or BTS_OPERATORS MicrosoftSQL Server database role.
In this scenario, the operation fails.

Issue 2

Assume that a user is a member of the BTS_HOST_USERS SQL Server database role, and BizTalk Server 2013 is installed on a computer. In this situation, the user cannot use an Electronic Data Interchange (EDI) pipeline to send or receive EDI messages on the computer.

↑ Back to the top


Cause

Cause of issue 1

This issue occurs because the SELECT permission is not granted to the BTS_HOST_USERS or BTS_OPERATORS SQL Server database role on the bts_dynamicport_subids and bts_dynamic_sendport_handlers Biztalk tables.

Cause of issue 2

This issue occurs because the EXECUTE permission is not granted to the BTS_HOST_USERS SQL Server database role on the [dbo].[adm_Group_Enum] stored procedure.

↑ Back to the top


Resolution

To resolve the issues, apply the fix that is described in the following Microsoft Knowledge Base (KB) article:
2830546 FIX: The vertical scroll bar on the target schema does not work correctly when you use Visual Studio to design a BizTalk Server 2013 map
Note Update 2830546 includes the fixes that are described in KB articles 2830546, 2832136 , and 2832137 .

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top


Workaround

To work around these issues, enable BAM alerts before you apply any configuration in BizTalk Server 2013.

↑ Back to the top


References

For information about the service packs and cumulative update list for BizTalk Server, click the following article number to view the article in the Microsoft Knowledge Base:
2555976 Service pack and cumulative update list for BizTalk Server
For more information about BizTalk Server hotfixes, click the following article number to view the article in the Microsoft Knowledge Base:
2003907 Information about BizTalk hotfixes and Service Pack support

↑ Back to the top


Keywords: kbqfe, kbfix, kbsurveynew, kbexpertiseadvanced, kb

↑ Back to the top

Article Info
Article ID : 2832136
Revision : 1
Created on : 1/7/2017
Published on : 4/9/2013
Exists online : False
Views : 362