A user is getting an error "Cannot update, database or object is read-only"
when creating a datasource.

The user has db_owner role of the database that's being connected to.

I know very little of Analysis Server and any help would be appreciated.

Thanks.

Ron

This is the typical error when two or more users are using SQL Analysis
Manager and the Olap repository is still in MS Access database, which it's
oppened in exclusive mode by Analysis Manager.

Try migrating Olap Repository to SQL Server and hopefully your problem is
gone.

Michael Prendergast


"Ron" <Ron (AT) discussions (DOT) microsoft.com> escribió en el mensaje
news:CC03234F-0585-41A7-8128-078EB865B5AA (AT) microsoft (DOT) com...

There's no Access involved - just SQL Server

Ron

"MPS" wrote:

How do you migrate the OLAP Repository (Access) to a SQL Server???


"MPS" wrote:

Open Analysis Manager, select the server name in the list (typically one),
right click over the server name and there you are, MIGRAR DEPOSITO in
Spanish, MIGRATE REPOSITORY I guess in English (I use Spanish version

You will need a DB created in SQL Server and connect to it with owner
privileges over that database


"Rodrigo" <Rodrigo (AT) discussions (DOT) microsoft.com> escribió en el mensaje
news:515C83DA-0157-4E12-9832-DAD3A18AC8E8 (AT) microsoft (DOT) com...

Just in case, default installation for MS Analysis Services manages Olap
repository in an Access Database.

Probably you do not have any data in Access, but the repository, if is not
migrated yet, It's still in a MS Access Database. The file is named
msmdrep.mdb and has two tables, OlapObjects and Server.

Hope it helps,

Michael Prendergast

"Ron" <Ron (AT) discussions (DOT) microsoft.com> escribió en el mensaje
news:6DB504F8-F1CB-4EFB-A216-8A50909012E5 (AT) microsoft (DOT) com...

That did the trick - Thanks MPS.

"MPS" wrote:

Good to hear that

Michael Prendergast

"Ron" <Ron (AT) discussions (DOT) microsoft.com> escribió en el mensaje
news:0727D691-8903-4472-97BC-1A9F65508608 (AT) microsoft (DOT) com...