Hello all,

We are using SQL Server 2000 Enterprise Edition as our
OLAP server. It has been performing very well until just
recently, when I have been unable to connect to the server
via Analysis Manager.

The error returned is :

"Cannot connect to the repository. Error: Unrecognized
database format"

The message also displays the path to the repository file,
which is correct.

The repository is stored as a mdb.

Cubes on the server can still be queried by OLAP viewing
tools.

I have reinstalled Analysis Services Service pack 3a and
restarted the server but the problem remains.

Has anyone come up against this problem? I am really not
sure what would be the best next step. Options I am
considering are:

 Attempt to open the mdb in Access with a view to
repairing it

 Attempt to migrate the repository from access to SQL
Server. From what I know though, this can only be done
via a wizard which is only available through Analysis
Manager which of course I cannot access.

 Reinstall Analysis Services

As well I am wondering what might have triggered the
problem. The server has only a few users at this stage
and is not experiencing heavy loads at all.

Any advice on this issue would be very much appreciated.
I have spent some time looking for similar cases but have
been unsuccessful.

Regards,

Jeremy

Hi,

yes try to repair it in Access. I had a similar problem once and it worked.
Make a backup and try it.


HTH,
Andrej


"Jeremy Selby" <anonymous (AT) discussions (DOT) microsoft.com> wrote