|
Home > Archive > BizTalk Server Setup > October 2004 > BizTalk configuration problems
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 |
BizTalk configuration problems
|
|
| stheby 2004-10-06, 2:47 am |
| Help!
I built a Windows Server 2003 enterprise edition machine from the ground
up and have been trying to get a BizTalk 2004 environment established
for last five days. I am following the latest "Installing BizTalk
Server" instructions but have experienced a number of problems.
The current issue is the existence of the following databases which are
prohibiting me from completing BizTalk configuration.
[6:14:49 PM Info ConfigHelper] Found existing database: BizTalkMgmtDb
[6:14:50 PM Info ConfigHelper] Found existing database: BizTalkMsgBoxDb
[6:14:50 PM Info ConfigHelper] Found existing database: BizTalkDTADb on
[6:14:51 PM Info BtsCfg] The database BizTalkAnalysisDb already exists
[6:14:51 PM Error BAMConfigWizExt] The database BAMAnalysis already
[6:14:51 PM Info ConfigHelper] Found existing database: BAMStarSchema
[6:14:51 PM Info ConfigHelper] Found existing database:BAMPrimaryImport
[6:14:51 PM Info ConfigHelper] Found existing database: BAMArchive on
The odd thing is that the BizTalkAnalysisDb and the BAMAnalysis database
names don't exist in my server's SQLserver database while the other six
databases do.
My questions: (1) should I delete the six databases from SQLserver and
attempt to run the ConfigFramework.exe again? (2) What should I do
about finding and removing the non-existent databases?
Thanks.
Stephen
| |
| Joe Eldridge \(MSFT\) 2004-10-06, 2:47 am |
| Yes, If the data in these databases is not needed delete the 6, To get to
the other 2 DB's you have to go into the analysis manager. I forget the
shortcut name but it is an MMC interface I think called "SQL analysis
services" not at computer with SQL currently, But essentially they are OLAP
databases and not SQL databases.
Hope this helps.
--
Joe Eldridge [MSFT]
This posting is provided "AS IS", with no warranties, and confers no rights.
"stheby" <stheby@drsys.com> wrote in message
news:10m6pa8s2559d5a@corp.supernews.com...
> Help!
>
> I built a Windows Server 2003 enterprise edition machine from the ground
> up and have been trying to get a BizTalk 2004 environment established for
> last five days. I am following the latest "Installing BizTalk Server"
> instructions but have experienced a number of problems.
>
> The current issue is the existence of the following databases which are
> prohibiting me from completing BizTalk configuration.
>
> [6:14:49 PM Info ConfigHelper] Found existing database: BizTalkMgmtDb
> [6:14:50 PM Info ConfigHelper] Found existing database: BizTalkMsgBoxDb
> [6:14:50 PM Info ConfigHelper] Found existing database: BizTalkDTADb on
>
> [6:14:51 PM Info BtsCfg] The database BizTalkAnalysisDb already exists
> [6:14:51 PM Error BAMConfigWizExt] The database BAMAnalysis already
>
> [6:14:51 PM Info ConfigHelper] Found existing database: BAMStarSchema
> [6:14:51 PM Info ConfigHelper] Found existing database:BAMPrimaryImport
> [6:14:51 PM Info ConfigHelper] Found existing database: BAMArchive on
>
> The odd thing is that the BizTalkAnalysisDb and the BAMAnalysis database
> names don't exist in my server's SQLserver database while the other six
> databases do.
>
> My questions: (1) should I delete the six databases from SQLserver and
> attempt to run the ConfigFramework.exe again? (2) What should I do about
> finding and removing the non-existent databases?
>
> Thanks.
>
> Stephen
| |
| stheby 2004-10-06, 5:51 pm |
| Joe Eldridge (MSFT) wrote:
> Yes, If the data in these databases is not needed delete the 6, To get to
> the other 2 DB's you have to go into the analysis manager. I forget the
> shortcut name but it is an MMC interface I think called "SQL analysis
> services" not at computer with SQL currently, But essentially they are OLAP
> databases and not SQL databases.
> Hope this helps.
>
Ok. Thanks.
I archived the two analytic databases and then deleted them and backed
up the 6 BizTalk databases and then deleted them.
After some additional account assignments in the messaging setup
section, the configuration finally completed. All the proper databases
were recreated and the item counts were at least as many as before;
some of the databases had more items such as stored procedures and
tables. Three new databases were added: rules, HSD and EDI.
I think the BizTalk install guide needs to add a step to backup the SSO
master secret and tell people how, ie., ssoconfig -backupsecret
mybackup.bak and where this utility resides. Otherwise, the application
log fills with 10589 ENTSSO errors (assuming the user is doing a fresh
install).
Another quick question-- when I run SSOMANAGE -showserver it results in
a "No SSO server is currently set" message; if I look at the running
services on my 2003 server, I don't see an SSO service started. But,
when I run SSOMANAGE -displaydb, it says the SSO server is Nanoquest (my
Windows 2003 box). I assumed that the BizTalk install sequence
automatically installed the SSO service since it asked whether my
machine was going to run this service or join an existing one and I
selected run it. Any ideas? Thanks again for the extremely quick
response last night.
Stephen
| |
| Joe Eldridge \(MSFT\) 2004-10-06, 5:51 pm |
| Good suggestion on the install guide, I will file a bug for that.
On the SSO issue, Did you run the command before or after config? Esentially
after install the SSO service is installed but not started until config is
run.
Does that help?
--
Joe Eldridge [MSFT]
This posting is provided "AS IS", with no warranties, and confers no rights.
"stheby" <stheby@drsys.com> wrote in message
news:10m8dl6j61l0c08@corp.supernews.com...
> Joe Eldridge (MSFT) wrote:
> Ok. Thanks.
>
> I archived the two analytic databases and then deleted them and backed up
> the 6 BizTalk databases and then deleted them.
>
> After some additional account assignments in the messaging setup section,
> the configuration finally completed. All the proper databases were
> recreated and the item counts were at least as many as before; some of the
> databases had more items such as stored procedures and tables. Three new
> databases were added: rules, HSD and EDI.
>
> I think the BizTalk install guide needs to add a step to backup the SSO
> master secret and tell people how, ie., ssoconfig -backupsecret
> mybackup.bak and where this utility resides. Otherwise, the application
> log fills with 10589 ENTSSO errors (assuming the user is doing a fresh
> install).
>
> Another quick question-- when I run SSOMANAGE -showserver it results in a
> "No SSO server is currently set" message; if I look at the running
> services on my 2003 server, I don't see an SSO service started. But, when
> I run SSOMANAGE -displaydb, it says the SSO server is Nanoquest (my
> Windows 2003 box). I assumed that the BizTalk install sequence
> automatically installed the SSO service since it asked whether my machine
> was going to run this service or join an existing one and I selected run
> it. Any ideas? Thanks again for the extremely quick response last night.
>
> Stephen
>
>
>
|
|
|
|
|