Microsoft KB Archive/917847

= The SQL Transport Schema Generation Wizard closes unexpectedly in BizTalk Server 2006 or in BizTalk Server 2004 =

Article ID: 917847

Article Last Modified on 6/6/2007

-

APPLIES TO


 * Microsoft BizTalk Server 2006 Standard Edition
 * Microsoft BizTalk Server 2006 Enterprise Edition
 * Microsoft BizTalk Server 2006 Developer Edition

-





SYMPTOMS
In Microsoft BizTalk Server 2006 or in Microsoft BizTalk Server 2004, the SQL Transport Schema Generation Wizard closes unexpectedly when you try to generate a schema for a SQL adapter send port. This problem occurs if you try togenerate a schema based off a database table in Microsoft SQL Server 2005 or in Microsoft SQL Server 2000 when one of the following conditions is true:
 * The logged on user who runs the wizard is not the database owner.
 * One of the following updategrams to update a database table is being used:
 * An Insert updategram
 * An Update updategram
 * A Delete updategram

Additionally, you may receive an error message that resembles the following:

Failed to execute SQL Statement. Please ensure that the supplied syntax is correct. New transaction cannot enlist in the specified transaction coordinator.

You may receive this error message when you use the SQL Transport Schema Generation Wizard to query a database table in SQL Server 2005 or in SQL Server 2000.



CAUSE
This problem occurs because one of the following conditions is true:  The SQL Server naming convention for database objects is as follows:

[ ].[ ].[ ].[ ]

By default, the value of  is the current server, and the value of   is the current database. By default, the value of  is the current user. The database table contains a column that has one of the following data types:  The varbinary(MAX) data type The varchar(MAX) data type The nvarchar(MAX) data type The xml data type</ul>

These data types are not supported by the SQL adapter in BizTalk Server.</li></ul>

<div class="resolution_section">

Resolution 1
Make sure that the logged on user who runs the wizard has DBO access to the database.

Resolution 2
The data types that are listed in the &quot;Cause&quot; section are new data types in SQL Server 2005. When the database table contains a column that has one of these data types, do not use the SQL adapter in BizTalk Server to insert data into the database table. Additionally, do not use the SQL adapter in BizTalk Server to retrieve data from the database table.

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

<div class="moreinformation_section">

MORE INFORMATION
For more information about data types in SQL Server 2005, visit the following Microsoft Developer Network (MSDN) Web site:

http://msdn2.microsoft.com/en-us/library/ms187752(SQL.90).aspx

For more information about support for BizTalk Server 2004 databases in SQL Server 2005, click the following article number to view the article in the Microsoft Knowledge Base:

915919 Microsoft SQL Server 2005 is not currently supported for Microsoft BizTalk Server 2004 databases

Keywords: kbbtsadapters kbbts kbtshoot kbprb KB917847

-

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

© Microsoft Corporation. All rights reserved.