Invalid Object Name 'OlapObjects'

We are using Microsoft Analysis Service with SP3 on Microsoft SQL Server. The Repository has been migrated to SQL server on the same machine. Recently for no reason, using Microsoft Analysis Manager, we would unable to log in to the repository. We have tried to do reinstallation of the Analysis Service component. After which when using local Analysis Manager to connect, it would show "Cannot connect to the repository. Analysis server: WEBTEST. Error: Not a valid account name or password."

Local Repository Connection String then was: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Microsoft Analysis Services\Bin\msmdrep.mdb

After confirming that the repository has been moved to SQL server, we changed the repository connection string to the following:

Local Repository Connection String:

Provider=SQLOLEDB.1;Password=sa_password;Persist Security Info=True;User ID=sa;Initial Catalog=DataMart; Data Source=WEBTEST;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=WEBTEST; Use Encryption for Data=False;Tag with column collation when possible=False

where DataMart was the database for the Analysis Service repository and WEBTEST is the server name.

After which when using local Analysis Manager to connect, it would show error "Invalid Object Name 'OlapObjects'".

Interestingly, when the Analysis Services component was just installed, the sample Food Mart also did not displayed.

Please advise on how to solve the problem, thank you.

It sounds as if something went wrong during migration. The error message makes me believe the OlapObjects table does not exist in the DataMart database. I would double-check the contents of this database. It should contain a Server table and an OlapObjects table.