sql 2008 R2 +Biztalk 2009 unable to configure group

Question

Please provide a detailed description of your issue or question along with any error messages so we may assist you.  Do not include any additional personal information when submitting this feedback.
I have a scenario of windows server 2008 R2 with Sql 2008r2 failover cluster and one more server that is BIztalk 2009 but I m not able to configure Group in BIztalk is there any compatibility issue.
Please let me inform ASAP.

Answer 1

BizTalk 2009 is not supported on SQL 2008 R2, only SQL 2008.

 

R2 will be supported with BizTalk 2010.

 

More information here: http://www.microsoft.com/biztalk/en/us/system-requirements.aspx

Answer 2

thanx a lot Alastair

Answer 3

is there any alternate option can we use biztalk 2006 r2

Answer 4

Are you getting an error when trying to configure the group?

Thanks,

---

If this answers your question, please use the "Answer" button to say so | Ben Cline

Answer 5

Hi,

Although Ben can help you out I do like to point to you to other thread on this forum discussing BizTalk 2009 and SQL Server 2008 R2. My opinion/thinking is to wait for BizTalk 2010 to align with SQL Server 2008 R2 and Windows 2008 R2, with VS 2010 to develop solutions.

Regards,

Steef-Jan Wiggers
MCTS BizTalk Server
http://soa-thoughts.blogspot.com/
If this answers your question please mark it accordingly

---

BizTalk

Answer 6

I know W2K8 R2 works fine with BizTalk 2009. I work on one production server for a client in this configuration. Microsoft has supported BizTalk in this configuration before.

Update:

I tried tried the configuration of BizTalk 2009 and SQL 2008 R2 and found out it is actually not compatible. You will always fail when trying to configure the BizTalk group. Here is a blog post I did on this: http://msinnovations.spaces.live.com/blog/cns!62E68922E47BC425!1260.entry

Thanks,

---

If this answers your question, please use the "Answer" button to say so | Ben Cline

Answer 7

In general BizTalk 2009 with SQL2008R2 is not supported, but it works.

Maybe you can give us a few more information about the error, so that we might be able to help you.

 

Kind regards

 

Answer 8

Hi Sandeep,

SQL server-2008R2 is incompatible with BizTalk server 2009, so thats wy we got error while try to configure Groups in BizTalk server Configuration Wizard.

it supports only SSO and Business Rule Engine services. So its better if we configure BizTalk-2009 with SQL server-2008.

SQL Server-2008R2 shows better compatibilty/Relaibililty with BizTalk Server-2010.

Thanks

/Harmeet Singh

---

Harmeet Singh Virk