BizTalk Server Setup - Re: Biztalk 2004 and SQL 2005

Author

Re: Biztalk 2004 and SQL 2005

Marcello Drewanz

2004-10-05, 8:46 pm

lawrenceguo wrote:

> Does anyone know whether Biztalk 2004 support SQL 2005 already? What
> I'm trying to do is to have Biztalk 2004 on one machine running
> windows 2003 and SQL 2005 on anohter machine running windows 2003 as
> well. Thanks in advance..
>
> Lawrence

Lawrence,

This is not a supported configuration by MS.
I tested it myself, the problem is the new native client from SQL2005.
If you have a previous installation of BTS2004 / SQL2000 and do the
migration to SQL2005 it will work (except for anything related to the
OLAP portion - BAM and others).

Again - It's not supported by MS, I would recommend setting another box
just to carry tests with SQL2005