Had an error today unlisted in any knowledge base I could quickly find and fixed it so I thought I'd post the fix here.

When attempting to connect to the Analysis Server, I received the error that msmdrep.mdb was an unrecognized database format. This file stores metadata in Access database format by default, although it can be migrated to SQL format on a SQL server. This disallowed access to all the cubes created on Analysis Server.

I don't know what the developer's did to cause the error. It looks as if it is possible this may happen in relation to installing DSO (decision support objects) or as a result of a botched migration to SQL format.

Shooting in the dark I simply made a copy of the file, ran the Access 2000 Convert database Utility, and the replaced the file in the Analysis Servicesin directory (after making renaming the old file of course).

This seems to have fixed the problem.

If anyone has notes on other possible causes or fixes, please let us know!

Ryan Pehrson