You receive an "Address Should be Unique" error message in BizTalk Server 2004 Explorer (842449)

The information in this article 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 "Symptoms" 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

Modification Type:	Major	Last Reviewed:	5/20/2005
Keywords:	kbprb KB842449 kbAudEndUser kbAudDeveloper