|
Home > Archive > BizTalk Server Setup > June 2004 > 'Unspecified Error' on Database configurations during Configuration Wizard
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 |
'Unspecified Error' on Database configurations during Configuration Wizard
|
|
| Ron Simmons 2004-04-01, 1:43 pm |
| I am attempting to get BTS2004 installed on two nodes of a cluster. SQL Server 2000 Enterprise was installed on the cluster and my understanding of BTS is that since it is not clusterable, I should install it on both nodes of my cluster and have each BTS
instance use the clustered SQL instance.
Someone else built the cluster and installed SQL Server, and unfortunately they are now overseas on military TDY and unavailable.
My BTS installation completes without error and when I choose to run the Configuration Wizard, all looks fine until I get to the Database Configurations, where I receive 'Unspecified Error' for both BAM Analysis Database and BizTalk Tracking Analysis Data
base. All other databases look fine. It is interesting that both of these entries in error show my local node as the Server while all of the other entries show my clustered SQL instance.
I suspect that my problem is somehow related to the cluster or to SQL Analysis Services on the cluster, since I have successfully done the BTS installation/configuration in a single machine environment. Unfortunately, I do not know how to validate SQL An
alysis Server in a cluster, but then again, I don't even know that this IS my problem.
Help?
My thanks in advance,
Ron Simmons
Electronic Data Systems
| |
| Paul Davidson 2004-06-26, 10:52 am |
| Open analysis manager in the SQL shortcut menu. If you can connect and
create a database, it's working fine. Unless you explicitly clustered
OLAP(http://support.microsoft.com/defaul...kb;en-us;308023), the
node name is the expected server name. Ensure you have installed SP3a for
OLAP, because SQL SP3a doesn't install it for you.
--------------------
Thread-Topic: 'Unspecified Error' on Database configurations during
Configuration Wizard
thread-index: AcQYGDvIUF6g/qQISx+VWvWr44JD2A==
X-Tomcat-NG: microsoft.public.biztalk.setup
From: "=?Utf-8?B?Um9uIFNpbW1vbnM=?=" <anonymous@discussions.microsoft.com>
Subject: 'Unspecified Error' on Database configurations during
Configuration Wizard
Date: Thu, 1 Apr 2004 10:36:23 -0800
Lines: 14
Message-ID: <95498FFE-553E-41F0-B9CC-1D617B80B3ED@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.biztalk.setup
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.biztalk.setup:3398
NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
X-Tomcat-NG: microsoft.public.biztalk.setup
I am attempting to get BTS2004 installed on two nodes of a cluster. SQL
Server 2000 Enterprise was installed on the cluster and my understanding of
BTS is that since it is not clusterable, I should install it on both nodes
of my cluster and have each BTS instance use the clustered SQL instance.
Someone else built the cluster and installed SQL Server, and unfortunately
they are now overseas on military TDY and unavailable.
My BTS installation completes without error and when I choose to run the
Configuration Wizard, all looks fine until I get to the Database
Configurations, where I receive 'Unspecified Error' for both BAM Analysis
Database and BizTalk Tracking Analysis Database. All other databases look
fine. It is interesting that both of these entries in error show my local
node as the Server while all of the other entries show my clustered SQL
instance.
I suspect that my problem is somehow related to the cluster or to SQL
Analysis Services on the cluster, since I have successfully done the BTS
installation/configuration in a single machine environment. Unfortunately,
I do not know how to validate SQL Analysis Server in a cluster, but then
again, I don't even know that this IS my problem.
Help?
My thanks in advance,
Ron Simmons
Electronic Data Systems
|
|
|
|
|