BizTalk Server Setup - Configuring BizTalk against SQL Cluster

Author

Configuring BizTalk against SQL Cluster

Mohan

2005-02-08, 5:50 pm

From: "Mohan" <Mohan@discussions.microsoft.com>
Subject: Error while Configuring BizTalk 2004 against SQL Server Cluster
Date: Tuesday, February 08, 2005 8:03 PM

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

Nathan Jeffery [MSFT]

2005-02-09, 5:49 pm

It is not clear what the problem is from your description. I was wondering if you could attach the log file for the run. the file
should be in the form Config<TimeStamp>.log. That will probably contain the information to find out what exactly happened.

Note: This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
From: "Mohan" <mohansamyREMOVETHIS@hotmail.comREMOVETHIS>
Subject: Configuring BizTalk against SQL Cluster
Date: Tue, 8 Feb 2005 23:19:04 +0530
Lines: 59
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.3790.181
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181
Message-ID: <eoOdDagDFHA.3256@tk2msftngp13.phx.gbl>
Newsgroups: microsoft.public.biztalk.setup
NNTP-Posting-Host: 203.124.141.105
Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.setup:5345
X-Tomcat-NG: microsoft.public.biztalk.setup

From: "Mohan" <Mohan@discussions.microsoft.com>
Subject: Error while Configuring BizTalk 2004 against SQL Server Cluster
Date: Tuesday, February 08, 2005 8:03 PM

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

Sorry I don't take feature request for WinRes: it belongs to the .NET Framework SDK. I'm a consumer of WinRes, just like you...
--------------------
>From: Thomas Adams <thomas.o.adams@gmail.com>
>Newsgroups: microsoft.public.dotnet.internationalization
>Subject: RE: How to launch WinRes in full screen mode by another program?
>Date: 29 Sep 2004 19:31:46 GMT
>Organization: DFN.CIS Senior Customer
>Lines: 17
>Message-ID: < Xns9573DB02E2782thomasoadamsgmailcom@127
.0.0.1>
>References: <2qh8rpFvi6jiU1@uni-berlin.de> <r3R$vnkpEHA.3636@cpmsftngxa06.phx.gbl>
>X-Trace: news.uni-berlin.de cGk7xWd2iWxkO9HVbF7isQODBzMeOPRUidb0ZHc/H3nGY=
>User-Agent: Xnews/06.08.25
>X-Converter: MorVer Version 1.0.305
>Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!
newsfeed01.sul.t-online.de!t-online.de!fu-berlin.de!uni-berlin.de!not-for-mail
>Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.internationalization:947
>X-Tomcat-NG: microsoft.public.dotnet.internationalization
>
>Hi
>
>Your assumption is correct. I did not want to call out its long name
>since I didn't know if that could be regarded as breach of NDA.

>
>Thanks for the explanation. Do you take feature requests for WinRes?
>I'd like to see a "remember last size and location" some day...
>
>~T.
>
>xuy@online.microsoft.com (Xu Yang[MSFT]) wrote:
>
>
>--
>
> [Formerly appended fullquote was nuked by morver,
> the versatile morphing server.]
>

I'm afraid that LocStudio (when you say LS, I assume you are using LocStudio) does not have the option, and WinRes does
not remember its size and location when it was shut down.
If you are trying to call it in your own application, you can always use ProcessWindowStyle.Maximized when you start the
process.

--------------------
>From: Thomas Adams <me4@privacy.net>
>Newsgroups: microsoft.public.dotnet.internationalization
>Subject: How to launch WinRes in full screen mode by another program?
>Date: 11 Sep 2004 21:26:17 GMT
>Organization: DFN.CIS Senior Customer
>Lines: 9
>Message-ID: <2qh8rpFvi6jiU1@uni-berlin.de>
>X-Trace: news.uni-berlin.de 9sj2ViefNkwlw4tmA89WfA6mie8fmrCfbXqlIJqR
ehUb0=
>User-Agent: Xnews/06.08.25
>X-Face: #Rk@TOQ|^!ZG|&z6lA@-CY>/xB[Ei1mG*&S.+A5z;Ng?3OxX[#DVZw!"o!c`S|p

zsX-EkdZZ(IVnFRTX%!:Sv^L&Gk~s]
vJ@Z~%Rm@G]fr*r2P}u5*&k/-_2+&Qowj6hiJ1b$^JQf:uy9456HIdKq*B`NC##kyO,>7"Ztnav+=71b*"E+DIme;{i&)ii{#6e?i8P,1Xpc
[q0}i:Tm];B1
>X-Converter: MorVer Version 1.0.305
>Path: cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!
newsfeed01.sul.t-online.de!t-online.de!fu-berlin.de!uni-berlin.de!not-for-mail
>Xref: cpmsftngxa10.phx.gbl microsoft.public.dotnet.internationalization:902
>X-Tomcat-NG: microsoft.public.dotnet.internationalization
>
>Hi
>
>Let's imagine you're using a translation environment (LS) that's
>launching WinRes every now and then. Is it possible to open WinRes in
>full screen mode in this case? It's quite annoying that it doesn't
>remember if I switch it to full screen mode the next time it is invoked.
>
>thanks,
>Thomas
>

Niklas E

2005-02-10, 8:47 pm

I had some trouble with clustering and I was also able to create part of the
databases. I had to do things like this:
- ConfigFramework /u to delete the bad setup
- Delete the database that were created if part of them were created (Should
be in one transaction, but still some databases were created)
- msdtc.exe -resetlog
msdtc.exe -uninstall
reboot
msdtc.exe -install
- Make sure to use manually created domains groups for the BizTalk groups.
- Try both the DTCTester and the DTCPing tool to see if you have good
contact with the DTC.
- Try this hotfix:
Windows Server 2003 COM+ 1.5 Rollup Package 3 (883955)

Also update BizTalk 2004 to SP1 before running ConfigFramwork so you have
the latest fixes there as well.

Best regards
Niklas Engfelt

"Mohan" <mohansamyREMOVETHIS@hotmail.comREMOVETHIS> wrote in message
news:uhKNwmxDFHA.2804@TK2MSFTNGP14.phx.gbl...
> I have attached the Config. The config file shows a long wait on a WMI
> Call. After which the error i mentioned occurs.
>
> Cheers
> Mohan
>
> "Nathan Jeffery [MSFT]" <nathanj@online.microsoft.com> wrote in message
> news:dh53#kvDFHA.952@TK2MSFTNGXA01.phx.gbl...
> wondering if you could attach the log file for the run. the file
> the information to find out what exactly happened.
> rights.
> cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13
> .phx.gbl
> of
> sure
> set
> allow
> and
> Framework SDK. I'm a consumer of WinRes, just like you...
> <r3R$vnkpEHA.3636@cpmsftngxa06.phx.gbl>
> cGk7xWd2iWxkO9HVbF7isQODBzMeOPRUidb0ZHc/H3nGY=
> cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
> ul.t-online.de!
> newsfeed01.sul.t-online.de!t-online.de!fu-berlin.de!uni-berlin.de!not-for-ma
> il
> microsoft.public.dotnet.internationalization:947
> LocStudio) does not have the option, and WinRes does
> ProcessWindowStyle.Maximized when you start the
> 9sj2ViefNkwlw4tmA89WfA6mie8fmrCfbXqlIJqR
ehUb0=
> #Rk@TOQ|^!ZG|&z6lA@-CY>/xB[Ei1mG*&S.+A5z;Ng?3OxX[#DVZw!"o!c`S|p

zsX-EkdZZ(I
> VnFRTX%!:Sv^L&Gk~s]
> vJ@Z~%Rm@G]fr*r2P}u5*&k/-_2+&Qowj6hiJ1b$^JQf:uy9456HIdKq*B`NC##kyO,>7"Ztnav+
> =71b*"E+DIme;{i&)ii{#6e?i8P,1Xpc
> cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
> ul.t-online.de!
> newsfeed01.sul.t-online.de!t-online.de!fu-berlin.de!uni-berlin.de!not-for-ma
> il
> microsoft.public.dotnet.internationalization:902
>
>
>

Paul Davidson

2005-02-10, 8:47 pm

Looks like a backwards error message(bug) because your config xml reflects
your statement that server and db were entered correctly.

Does eventvwr show anything on the BTS or SQL node? Also, try creating the
database manually(via isqlw.exe, EM, etc) to see if SQL throws any
error.(tsql: "create database BAMArchive" then "drop database BAMArchive"
to clean up).

You'll have to delete the databases that were created before running config
again, or you can use different db names.
--------------------
From: "Mohan" <mohansamyREMOVETHIS@hotmail.comREMOVETHIS>
References: <eoOdDagDFHA.3256@tk2msftngp13.phx.gbl>
<dh53#kvDFHA.952@TK2MSFTNGXA01.phx.gbl>
Subject: Re: Configuring BizTalk against SQL Cluster
Date: Thu, 10 Feb 2005 08:08:52 +0530
Lines: 564
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.3790.181
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181
Message-ID: <uhKNwmxDFHA.2804@TK2MSFTNGP14.phx.gbl>
Newsgroups: microsoft.public.biztalk.setup
NNTP-Posting-Host: 203.124.141.105
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.biztalk.setup:2126
X-Tomcat-NG: microsoft.public.biztalk.setup

I have attached the Config. The config file shows a long wait on a WMI
Call. After which the error i mentioned occurs.

Cheers
Mohan

"Nathan Jeffery [MSFT]" <nathanj@online.microsoft.com> wrote in message
news:dh53#kvDFHA.952@TK2MSFTNGXA01.phx.gbl...
> It is not clear what the problem is from your description. I was
wondering if you could attach the log file for the run. the file
> should be in the form Config<TimeStamp>.log. That will probably contain
the information to find out what exactly happened.
>
> Note: This posting is provided "AS IS" with no warranties, and confers no
rights.
> --------------------
> From: "Mohan" <mohansamyREMOVETHIS@hotmail.comREMOVETHIS>
> Subject: Configuring BizTalk against SQL Cluster
> Date: Tue, 8 Feb 2005 23:19:04 +0530
> Lines: 59
> X-Priority: 3
> X-MSMail-Priority: Normal
> X-Newsreader: Microsoft Outlook Express 6.00.3790.181
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181
> Message-ID: <eoOdDagDFHA.3256@tk2msftngp13.phx.gbl>
> Newsgroups: microsoft.public.biztalk.setup
> NNTP-Posting-Host: 203.124.141.105
> Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13
.phx.gbl
> Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.setup:5345
> X-Tomcat-NG: microsoft.public.biztalk.setup
>
>
> From: "Mohan" <Mohan@discussions.microsoft.com>
> Subject: Error while Configuring BizTalk 2004 against SQL Server Cluster
> Date: Tuesday, February 08, 2005 8:03 PM
>
> 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
>
>
>
>
>
>
>
>
>
> Sorry I don't take feature request for WinRes: it belongs to the .NET
Framework SDK. I'm a consumer of WinRes, just like you...
> --------------------
<r3R$vnkpEHA.3636@cpmsftngxa06.phx.gbl>[vbcol=seagreen]
cGk7xWd2iWxkO9HVbF7isQODBzMeOPRUidb0ZHc/H3nGY=[vbcol=seagreen]
cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de![vbcol=seagreen]
>
newsfeed01.sul.t-online.de!t-online.de!fu-berlin.de!uni-berlin.de!not-for-ma
il
microsoft.public.dotnet. internationalization:947[vbcol=seagreen]

>
> I'm afraid that LocStudio (when you say LS, I assume you are using
LocStudio) does not have the option, and WinRes does
> not remember its size and location when it was shut down.
> If you are trying to call it in your own application, you can always use
ProcessWindowStyle.Maximized when you start the
> process.
>
> --------------------
9sj2ViefNkwlw4tmA89WfA6mie8fmrCfbXqlIJqR
ehUb0=[vbcol=seagreen]
#Rk@TOQ|^!ZG|&z6lA@-CY>/xB[Ei1mG*&S.+A5z;Ng?3OxX[#DVZw!"o!c`S|p

zsX-EkdZZ(I
VnFRTX%!:Sv^L&Gk~s][vbcol=seagreen]
>
vJ@Z~%Rm@G]fr*r2P}u5*&k/-_2+&Qowj6hiJ1b$^JQf:uy9456HIdKq*B`NC##kyO,>7"Ztnav+
=71b*"E+DIme;{i&)ii{#6e?i8P,1Xpc
> [q0}i:Tm];B1
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de![vbcol=seagreen]
>
newsfeed01.sul.t-online.de!t-online.de!fu-berlin.de!uni-berlin.de!not-for-ma
il
microsoft.public.dotnet. internationalization:902[vbcol=seagreen]

>
>