locked
BizTalk Server 2004 with application database on SQL Server 2008 RRS feed

  • Question

  • Hello,

    We are currently migration our application on .NET 1.1 on SQL 2005  to .NET 4.0 with SQL Server 2008 as application database; our application also uses BizTalk Server 2004 for business needs which has BizTalk databases only SQL Server 2000 (different server).

    Communication between application and BizTalk is solely implemented thru application database with the help of BizTalk adapters. And we have about 6 SQL adapters and 3 File adapters in our application. All these SQL adapters rely on application database currently on SQL 2005 (current application database) for inputs to execute business logic defined in BizTalk application.

    With the migration in place, we now need to have SQL adapters of BizTalk Server 2004 (BizTalk still utilizing the its native SQL 2000 for its databases) to get inputs from application database on SQL 2008.

    So, currently we are having issues with installing our BizTalk application on BizTalk Server 2004; The installation fails at the end while creating receive locations which are basically SQL adapters. The error info which we get is below:

    Failed updating binding information. BindingException: Could not validate TransportTypeData, Address or Public Address properties for Receive Location 'USES.BizTalk.Task.Receive1.3.3'. Exception from HRESULT: 0x80131500.

    Also please find the output file that is generated while installing our application. 

    I now doubt that "Will the BizTalk server 2004 be able to communicate with application a database on SQL Server 2008". It did work well when the application database is on SQL 2005.

    Can anyone give suggestion on how to resolve the issues or can confirm that biztalk server 2004 will not be able to act with application database on sql 2008 with sql adapters.

    If we can get any references on these would also be very helpful and Its much greatful and appreicated.


    Friday, September 21, 2012 3:43 PM

Answers

All replies

  • I think BizTalk 2004 will not support SQL server 2008

    see this

    http://support.microsoft.com/kb/926628


    If this post answers your question, please mark it as such. If this post is helpful, click 'Vote as helpful'.


    Friday, September 21, 2012 4:01 PM
  • Thanks for the response. I did find this article while I was Google-ing. But this article is not related to our concern here.

    The article is about "which SQL Server versions are supported for BizTalk Software Application databases (eg, BizTalk Server 2004 databases are BizTalkDTADb, BizTalkMgmtDb etc).

    Our concern is that, can a BizTalk application installed on BizTalk Server 2004 (with SP 2) be used with an application (our user application) that uses SQL 2008; This would require BizTalk Server 2004 (that runs on SQL Server 2000 for BizTalk software application databases) communicate with SQL 2008 for inputs from application (our user application) database for executing the tasks in our user application installed on BizTalk Server 2004.

    Your inputs are very valued. Thanks.

    Friday, September 21, 2012 6:57 PM
  • The SQL Adapter for BizTalk Server 2004 uses SQLXML 3.0 with Service Pack 2 for doing the XML communication with the SQL Server. To my understanding this should work with all SQL Servers that supports "for xml" clauses (2000+) (Not 100% certain though)

    Also it seems that the error you are getting is when importing your binding file to a new BizTalk environment? At this point BizTalk would not even be aware of which SQL Server version it will later communicate with, once the Receive Location is actually Enabled. 

    So my guess is that something else is wrong in your binding file or basic BizTalk/SQL Adapter set up. Why do you need to update the binding information in BizTalk if all you did was update your application database? On a "good day" BizTalk should be total unaware of this, maybe just need a different SQL Server name/address on the Send Ports and/or Receive Locations pointing to the application.

    Morten la Cour

    Saturday, September 22, 2012 5:31 AM
  • Hello la Cour,

    Thanks for responding, we did cross checked our binding file quite a few times and also compared it with previous versions too; the binding file is clean.

    And we also did installing our application on the same BizTalk server (with which we are facing issues as said above) having the SQL adapters in the binding file pointing to a different SQL Server (SQL 2005), as suggested, the application was installed with out any issues. Also the receive locations stay are enabled.

    So, until with our analysis on this, it turned out that we could not install our user Biztalk application on this server when our application DB uses SQL 2008.

    Any suggestions are a great welcome. Thanks. 

    Monday, September 24, 2012 3:01 PM
  • Please, See this article 

    BizTalk: Timeline: Platform Support


    Leonid Ganeline [BizTalk MVP] BizTalkien: Advanced Questions

    Wednesday, November 28, 2012 3:54 AM
    Moderator