SQL Adapter – cannot connect

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › SQL Adapter – cannot connect

Viewing 2 reply threads
  • Author
    Posts
    • July 12, 2010 at 5:32 AM #25196
      community-content

        Hi folks,

        I’ve a problem I did not understand at all.

        I want to add a SQL adapter (project – add – add generated items – add adapter metadata –

        and then … no dialog for choosing what adapter I want to add. I get an error message, that there is no connection to the database. But what database? I didn’t even selected one?

        error message:
        An error occured during wizzard execution.
        BizTalkServer cannot access SQL Server. …

        I’ve done this before some times, and it works fine. But I think, we switched from SQL Server 2005 to 2008 some Month ago. Maybe this could be an hind. The SQL server is running on a seperate server, not local on my development system.

        Would be fine if someone knows what to do or any work around.

        thx in advance

      • July 12, 2010 at 8:01 AM #25201
        community-content

          After migrated from SQL 2005 to 2008, you have to reconfigure the BizTalk server DB to 2008. You can check these BTS sql configuration with biztalk configuration exe file (in the root folder).

          Regards

          Benit

          • July 12, 2010 at 8:24 AM #25203
            community-content

              Sorry, but what exactly do u mean?

              The configuration looks fine. Do I have to unconfigure everything and reconfigure it again?

          • July 12, 2010 at 12:28 PM #25209
            community-content

              Hi Roland,

               

                 Have you tried conecting to that SQL Server 2008 database from BizTalk using the WCF SQL Adapter? That would be a good use for forward compatibility when migrating to BizTalk Server 2009 (as SQL Adapter is deprecated in that version).

               

                 Daniel.

               

          • Author
            Posts
          Viewing 2 reply threads
          • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.