Help and Support
 

powered byLive Search

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

View products that this article applies to.
Article ID:915919
Last Review:March 16, 2007
Revision:1.2

INTRODUCTION

Microsoft SQL Server 2005 is not currently supported for Microsoft BizTalk Server 2004 databases. The BizTalk Server databases must be configured on Microsoft SQL Server 2000 with Service Pack 3a (SP3a) or a later version of SQL Server 2000. Or, the BizTalk Server databases must have remote access to an installation of SQL Server 2000 SP3a or a later version of SQL Server 2000.

Back to the top

MORE INFORMATION

You can use the SQL receive adapter for BizTalk Server 2004 or the SQL send adapter for BizTalk Server 2004 to read or write data to SQL Server 2005 on a remote server.

BizTalk Server 2004 does not support using any new SQL Server 2005 functionality with the SQL adapter, such as the new primitive data types that are included with SQL Server 2005. For example, the adapter does not currently support new XML data types in schema generation.

Back to the top

REFERENCES

For more information about how to connect applications by using native adapters, visit the following Microsoft Developer Network (MSDN) Web site:
http://msdn2.microsoft.com/en-us/library/ms916013.aspx (http://msdn2.microsoft.com/en-us/library/ms916013.aspx)

Back to the top

APPLIES TO
•Microsoft BizTalk Server 2004 Standard Edition
•Microsoft BizTalk Server 2004 Enterprise Edition
•Microsoft BizTalk Server 2004 Developer Edition
•Microsoft BizTalk Server 2004 Partner Edition

Back to the top

Keywords: 
kbbtsadapters kbsetup kbinfo KB915919

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by E-mail, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.