Ron,

I have a similar problem when I was configuring the BAM databases (albeit on
 a standalone install).  I solved this problem by installing the Analysis Se
rver Service Pack3 which requires a re-boot but after that, everything worke
d just great.

See how you get on.

Regards
Ben

"Ron Simmons" wrote:

> I am attempting to get BTS2004 installed on two nodes of a cluster.  SQL Server 20
00 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 eac
h B
TS 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 Configura
tion Wizard, all looks fine until I get to the Database Configurations, where I rece
ive 'Unspecified Error' for both BAM Analysis Database and BizTalk Tracking Analysis
 Da
tabase.  All other databases look fine.  It is interesting that both of these entries in err
or show my local node as the Server while all of the other entries show my clustered SQL ins
tance.
>
> I suspect that my problem is somehow related to the cluster or to SQL Analysis Ser
vices on the cluster, since I have successfully done the BTS installation/configurat
ion in a single machine environment.  Unfortunately, I do not know how to validate S
QL
Analysis Server in a cluster, but then again, I don't even know that this IS my problem.[vbc
ol=seagreen]
>
> Help?
>
> My thanks in advance,
>
> Ron Simmons
> Electronic Data Systems[/vbcol]

[ Post a follow-up to this message ]