|
| Hi,
I am trying to configure Biztalk 2004 with the BizTalk Databases on SQL
Server 2000 two node cluster. The cluster is up and i shut down one node of
the SQL Server.
I run the ConfigFramework.exe to configure BizTalk. After collecting all
configuration option the configuration starts. But it times out after a while
giving the following error:
-----------------------------------
[6:37:20 PM Error BAMConfigWizExt] Deploying BAM infrastructure:
Failed to set up BAM database(s).
Failed to set up database SDC-VSQL-01 on server BAMArchive. Please make sure
the SQL server is functional and connected.
Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.
--------------------------------------
My observations:
1. After this configuration failure i checked the SQL Server. I find that
four of the BizTalk Server Databases are created. ( BAMPrimaryImport,
BizTalkDTADb,BizTalkMsgBoxDB and BizTalkMgmtDB). But rest of the databases
are not created.
2. Very peculiar Point about the error log: Error log reports "Failed to set
up database SDC-VSQL-01 on server BAMArchive." . The funny thing is my
virtual SQL server name is SDC-VSQL-01 and the database that should be
created is BAMArchive. The error message above says that my database is
SDC-VSQL-01 and server is BAMArchive. The configuration exe will never allow
us to provide a non-existing DB server. My inputs to the config exe are
correct. I was wondering whether the config exe is trying to access a
non-existing server.
3. I have setup the BizTalk server before on a single box with SQL and
BizTalk on the same machine. I didnot face any problems in configuration.
4. I have setup BizTalk on a two box configuration too..One for BizTalk and
one for SQL Server. I never faced this problem during that.
5. This is the first time i am trying to configure BizTalk against a
cluster. And this is the first time i am getting such a timeout error.
6. I have increased the timeout on the MSDTC to 600 seconds. Still no success.
7. I have tried the hotfix mentioned in
http://support.microsoft.com/defaul...kb;en-us;843543 . Still no
success.
I am stumped. Anyone out there faced this problem? Let me know..
Cheers
Mohan
|
|