Microsoft KB Archive/842449

= You receive an &quot;Address Should be Unique&quot; error message in BizTalk Server 2004 Explorer =

Article ID: 842449

Article Last Modified on 5/20/2005

-

APPLIES TO


 * Microsoft BizTalk Server 2004 Developer Edition
 * Microsoft BizTalk Server 2004 Enterprise Edition
 * Microsoft BizTalk Server 2004 Partner Edition
 * Microsoft BizTalk Server 2004 Standard Edition

-



SYMPTOMS
When you use the Microsoft BizTalk Server 2004 Explorer (BizTalk Explorer) to create a receive location that uses the SQL transport type, you may receive the following error message in the BizTalk Explorer:

Address Should be Unique

This behavior may occur when the following conditions are true:
 * You configure multiple receive locations in a BizTalk Group to use the SQL transport.
 * These receive locations are configured by using a URI that points to the same SQL Server database.



CAUSE
For any particular BizTalk Group, if you create two or more SQL adapter receive locations against the same SQL Server database, BizTalk Server will generate the same Address (URI). Therefore, you receive the error message described in the &quot;Symptoms&quot; section.



WORKAROUND
To work around this behavior, manually change the Address (URI) property to a unique name.

For example, if you have two receive locations that each have an Address (URI) property value that is set to SQL://./Northwind/, change the second Address (URI) property value to SQL://./NorthwindSecondary/.

Note The Address (URI) property is located in the Receive Location Properties - Configuration dialog box under General.



MORE INFORMATION
For more information about BizTalk Server 2004, visit the following Microsoft Web site.

http://www.microsoft.com/biztalk

Additional query words: BTS

Keywords: kbprb KB842449

-

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

© Microsoft Corporation. All rights reserved.