When trying to configure Biztalk I receive the following error:

[2:48:47 PM Error BtsCfg] Failed to create subscription database
"BizTalkMsgBoxDb" on server "SQLSRV\BTS01".
Statement(s) could not be prepared.
Conflicting locking hints specified.
Conflicting locking hints specified.
Conflicting locking hints specified.

SQL script file: "C:\Program Files (x86)\Microsoft BizTalk Server
2004\Schema\\msgboxlogic.sql"
SQL command batch: "CREATE PROCEDURE
[dbo].[int_PurgeMessageZeroSumTable]
@fAggressive int
AS
declar..."


I know this issue has been posted before, but these postings did not
lead me to anything that has helped resolve this.  I am using Biztalk
2004 and pointing to a SQL 2005 database on a different machine.

Using the same saved configuration file and pointing it to different
databases, I was able to get it to work pointing to a SQL 2000 on the
same box as Biztalk.  I was also able to get it to work pointing to SQL
2000 on a different box than Biztalk.

Has anyone else experienced this, or know what might be causing this?
Could it be something related to SQL 2005 & Biztalk 2004?  Any help
would be greatly appreciated.

Thanks,
Brian

[ Post a follow-up to this message ]

Brian,

> [2:48:47 PM Error BtsCfg] Failed to create subscription database
> "BizTalkMsgBoxDb" on server "SQLSRV\BTS01".
> Statement(s) could not be prepared.
> Conflicting locking hints specified.
> Conflicting locking hints specified.
> Conflicting locking hints specified.
>
> SQL script file: "C:\Program Files (x86)\Microsoft BizTalk Server
> 2004\Schema\\msgboxlogic.sql"
> SQL command batch: "CREATE PROCEDURE
> [dbo].[int_PurgeMessageZeroSumTable]
> @fAggressive int
> AS
> declar..."
>
>
> I know this issue has been posted before, but these postings did not
> lead me to anything that has helped resolve this.  I am using Biztalk
> 2004 and pointing to a SQL 2005 database on a different machine.
>
> Using the same saved configuration file and pointing it to different
> databases, I was able to get it to work pointing to a SQL 2000 on the
> same box as Biztalk.  I was also able to get it to work pointing to SQL
> 2000 on a different box than Biztalk.
>
> Has anyone else experienced this, or know what might be causing this?
> Could it be something related to SQL 2005 & Biztalk 2004?  Any help
> would be greatly appreciated.

BizTalk 2004 is not compatible with SQL 2005; you need to use SQL 2000 for
it. BizTalk 2006, however, will support SQL 2005 for the system databases.


--
Tomas Restrepo
tomasr@mvps.org
http://www.winterdom.com/

[ Post a follow-up to this message ]