Hi,

I have a clustered SQL server 2000 to host the BizTalk Server 2004 database
and 2 BizTalk servers installed sharing the same database, My first problem
is when I use the BtsInstaller.msi DEPLOY=true (this works fine in all other
single server environment) on one of the BizTalk Server box and I got the
error stating that SQL Server does not exist!

Then I tried to use deploy wizard, I can deploy assembly from one BizTalk
Sever but I could not deploy the assembly from another box - I got
"Unspecified exception: An error occurred while enlisting in a distributed
transaction" - I should say the DTC works fine on SQL because I can deploy
it from another BizTalk Server. I configured this two BizTalk server almost
identical then only difference is that one host the SSO service (I can
deploy the assembly from the BizTalk Server that host the SSO)

Any help and tips will be greatly appreciated!

Thank you very much!
John

[ Post a follow-up to this message ]

Hi,

I have fixed the 2nd problem by creating a dns entry for my 2nd box.

I still could not make the msi work - it always states SQL does not exist!

John

"John Lee" <john.nospam@pursca.com> wrote in message
news:OmBZbTksEHA.3200@TK2MSFTNGP14.phx.gbl...
> Hi,
>
> I have a clustered SQL server 2000 to host the BizTalk Server 2004
> database and 2 BizTalk servers installed sharing the same database, My
> first problem is when I use the BtsInstaller.msi DEPLOY=true (this works
> fine in all other single server environment) on one of the BizTalk Server
> box and I got the error stating that SQL Server does not exist!
>
> Then I tried to use deploy wizard, I can deploy assembly from one BizTalk
> Sever but I could not deploy the assembly from another box - I got
> "Unspecified exception: An error occurred while enlisting in a distributed
> transaction" - I should say the DTC works fine on SQL because I can deploy
> it from another BizTalk Server. I configured this two BizTalk server
> almost identical then only difference is that one host the SSO service (I
> can deploy the assembly from the BizTalk Server that host the SSO)
>
> Any help and tips will be greatly appreciated!
>
> Thank you very much!
> John
>

[ Post a follow-up to this message ]