Biztalk 2004 Configuration

This is probably because you do not have the right service packs installed for SQL.

Make sure you have 3a. I do not think it works with just 3 and there is no way that I know of to tell if you have 3 or 3a installed.

You also need 3a installed for Analysis Services.