|
Home > Archive > BizTalk Server Setup > December 2005 > Failed to create subscription database
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Failed to create subscription database
|
|
|
| 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
| |
| Tomas Restrepo \(MVP\) 2005-12-10, 5:53 pm |
| 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/
|
|
|
|
|