Hi,

As far as I know, Biztalk 2004 is not supported with SQL
Server 2005 and Biztalk might not work/installed properly.

I hear some blogs that Micorosft is currently working on
this for a future release next year.

Hope this helps.
Deepak
http://deepakl.blogspot.com

>-----Original Message-----
>My first attenp to configure Biztalk 2004 was
with 'Analysis service support'
>but after getting same error saying some thing
connection string must be
>present in <DSO> </DSO> in file msmdsrv.ini.
>
>Then i tried without Analysis service support. and got
following error. i
>did re-configuration with configframework.exe /u, and i
also deleted all
>Biztalk database from SQL Server 2005 before rerunning
the setup.
>
>-----------------------------------------------
>
>Deploying BAM Infrastructure:
>Failed to set up BAM database(s).
>Invalid column name 'XLOCK'.
>Invalid column name 'ROWLOCK'.
>Parameters supplied for
object 'dbo.bam_Metadata_RTAMutex' which is not a
>fucntion.
>
>-------------------------------------------------
>
>Log File says
>
>------------------------------------------------
>
>--->
>
>[12:05:27 PM Info ConfigFramework] Waiting for
configuration thread to
>complete.
>[12:05:38 PM Info ConfigFramework] Waiting for
configuration thread to
>complete.
>[12:05:39 PM Info ConfigFramework] Showing MessageBox
with text: Deploying
>BAM infrastructure:
>Failed to set up BAM database(s).
>Invalid column name 'XLOCK'.
>Invalid column name 'ROWLOCK'.
>Parameters supplied for
object 'dbo.bam_Metadata_RTAMutex' which is not a
>function.
>  Return Code: 2
>[12:05:39 PM Error ConfigFramework]
>c:\depot4000
 \jupiter\source\private\common\configwiz
ard\exe\configthre
ad.cpp(556): FAILED hr = 80004005
>
>[12:05:39 PM Error ConfigFramework]
> ****************************************
******
>[12:05:39 PM Error ConfigFramework] *** Configuration
failed - Rolling
>back... ***
>[12:05:39 PM Error ConfigFramework]
> ****************************************
******
>[12:05:39 PM Error ConfigFramework] Configuration
failed - rolling back...
>[12:05:39 PM Info ConfigFramework] Retrieved cached
IConfig object for
>feature: BAMTools ProgID: MSEBiz.BAMConfigWizExt
>[12:05:39 PM Warning ConfigFramework] Rolling back
feature: Business
>Activity Monitoring tools
>[12:05:39 PM Info BAMConfigWizExt] Entering function:
>CBAMConfigWizExt::UnConfigureFeature
>[12:05:39 PM Info BAMConfigWizExt] Leaving function:
>CBAMConfigWizExt::UnConfigureFeature
>[12:05:39 PM Info ConfigFramework] Retrieved cached
IConfig object for
>feature: BAMAdministration ProgID: MSEBiz.BAMConfigWizExt
>[12:05:39 PM Warning ConfigFramework] Rolling back
feature: Business
>Activity Monitoring Administration
>[12:05:39 PM Info BAMConfigWizExt] Entering function:
>CBAMConfigWizExt::UnConfigureFeature
>[12:05:39 PM Info BAMConfigWizExt] Leaving function:
>CBAMConfigWizExt::UnConfigureFeature
>[12:05:39 PM Info ConfigFramework] Retrieved cached
IConfig object for
>feature: WMI ProgID: MSEBiz.BtsCfg
>[12:05:39 PM Warning ConfigFramework] Rolling back
feature: BizTalk WMI
>[12:05:39 PM Info BtsCfg] Entering function:
 CBtsCfg::UnConfigureFeature
>[12:05:39 PM Info BtsCfg] 	Unconfiguring feature: WMI
>[12:05:39 PM Info BtsCfg] Entering function:
CWMI::Connect
>[12:05:39 PM Info BtsCfg] WMI is already connected
>[12:05:39 PM Info BtsCfg] Leaving function: CWMI::Connect
>[12:05:39 PM Info BtsCfg] Entering function:
CWMI::DeleteServer
>[12:05:40 PM Info BtsCfg] Entering function:
CWMI::UnConfigureGroup
>[12:05:40 PM Info BtsCfg] Leaving function:
 CBtsCfg::UnConfigureFeature
>[12:05:40 PM Info ConfigFramework]
 *************************
>[12:05:40 PM Info ConfigFramework] *** Rollback complete
***
>[12:05:40 PM Info ConfigFramework]
 *************************
>[12:05:40 PM Info ConfigFramework] Configuration
complete.
>[12:05:40 PM Info ConfigFramework] Configuration thread
finished.
>[12:05:40 PM Info ConfigFramework] Configuration thread
has ended.
>[12:05:40 PM Info ConfigHelper] 	Retrieved
INSTALLDIR: C:\Program
>Files\Microsoft BizTalk Server 2004\
>
>.
>

[ Post a follow-up to this message ]