Microsoft KB Archive/316012

= PRB: You Cannot View Trading Partners in the Trading Partner Management Module of Commerce Server Business Desk =

Article ID: 316012

Article Last Modified on 6/25/2004

-

APPLIES TO


 * Microsoft BizTalk Accelerator for Suppliers 1.0 Service Pack 1

-



This article was previously published under Q316012



SYMPTOMS
When you attempt to create a trading partner profile in the Trading Partner Management module of the Microsoft Commerce Server Business Desk, there are no BizTalk Transport Channels listed. This behavior occurs if you install BizTalk Accelerator for Suppliers with BizTalk Server 2002.



CAUSE
This problem occurs because the Microsoft Commerce Server 2000 Business Desk and the Microsoft BizTalk Server 2002 Trading Partner database use different Microsoft SQL Server security architectures. Because of this difference, the user context in which the Business Desk is running cannot be properly authenticated to retrieve the channel information from the BizTalk Server 2002 database.



RESOLUTION
To resolve the problem of the security architecture difference between Commerce Server 2000 and BizTalk Server 2002, you need to grant the proper user account access to the SQL Server database.

To grant the user account the proper permissions:  Start SQL Server Enterprise Manager. Connect to the appropriate SQL server. Browse to the SQL Server\Security folder. Create a new logon profile. In the Create New Login dialog box:  On the General tab: <ul> For Name, type:

\AFSU_

</li> For Default Database, type:

InterchangeBTM

</li></ul> </li> On the Database Access tab: <ul> Give access permission to the InterchangeBTM database.</li> Specify public and   as the roles for the InterchangeBTM database.</li></ul> </li></ul> </li> Click OK to accept the changes.</li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article. The issue will be corrected in the next version of this product.

Additional query words: BizDesk

Keywords: kbfix kbprb KB316012

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.