BAM (BTS 2004) Connection Failed – Server name not set…. error message

by | May 23, 2007 | BizTalk Community Blogs via Syndication

I’m doing a bit of BAM at the moment (BTS 2004) and came across this:

C:\Program
Files\Microsoft BizTalk Server 2004\Tracking>bm deploy c:\projects\bt
s_bam\BAM_CreateQuote_Validate.xls
Retrieving BAM Definition XML from Excel workbook … Done!
Deploying PrimaryImportDatabase … Done!
Deploying StarSchemaDatabase … Done!
Deploying AnalysisDatabase …
BAM deployment failed.
Failed to deploy BAM Analysis database.
Failed to connect to Olap server. Please make sure the Analysis Server is funct
ional.
Connection failed: Server name not set.

Problem turns out to lie in the BamConfiguration.xml (found under
…\Microsoft BizTalk Server 2004\Tracking) file – on this particular machine I installed
the bits for BAM after the initial install. Hence why BTS is complaining that it only
has half the BAM Picture.

I added in some server + database names and we’re all good to go!!!

Note: when running ‘bm.exe’ from a batch file, it will look for a BAMConfiguration.xml
file nearby – if it can’t find one, there’s alot of kicking and screaming.
So as a rule of thumb, CD to the above \Tracking folder and run bm.exe from
there.

Sample BAMConfiguration.xml file

<?xml
version=”1.0″ encoding=”utf-8″?>
<BAM:BAMConfiguration xmlns:BAM=”urn:schemas-microsoft.com:BAM” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance”>
    <DeploymentUnit Name=”PrimaryImportDatabase”>
        <Property Name=”ServerName”>myserver</Property>
        <Property Name=”DatabaseName”>BAMPrimaryImport</Property>
        <Property Name=”RTAWindow”>3600</Property>
        <Property Name=”RTATimeSlice”>300</Property>
    </DeploymentUnit>
    <DeploymentUnit Name=”StarSchemaDatabase”>
        <Property Name=”ServerName”>myserver</Property>
        <Property Name=”DatabaseName”>BAMStarSchema</Property>
    </DeploymentUnit>
    <DeploymentUnit Name=”AnalysisDatabase”>
        <Property Name=”ServerName”>myserver</Property>
        <Property Name=”DatabaseName”>BAMAnalysis</Property>
    </DeploymentUnit>
    <DeploymentUnit Name=”ArchivingDatabase”>
        <Property Name=”ServerName”>myserver</Property>
        <Property Name=”DatabaseName”>BAMArchive</Property>
    </DeploymentUnit>
    <DeploymentUnit Name=”CubeUpdateDTS”>
        <Property Name=”ConnectionTimeOut”>15</Property>
        <Property Name=”UseEncryption”>1</Property>
    </DeploymentUnit>
    <DeploymentUnit Name=”DataMaintenanceDTS”>
        <Property Name=”ConnectionTimeOut”>15</Property>
        <Property Name=”UseEncryption”>1</Property>
    </DeploymentUnit>
</BAM:BAMConfiguration>